Edits an attribute of an external product. This replaces existing values.
Input
Parameter | Type | Description |
|---|---|---|
v_product_id | NUMBER | The id of the product to be edited. |
v_acronym | VARCHAR2 | The acronym of the attribute |
v_value | VARCHAR2 | The value to be assigned to the attribute. An empty string represents an UNKNOWN value. NULL is not supported, use removeProductttribute instead. |
Example
SQL> select product_id, acronym, data from external_product_attributes_vw;
PRODUCT_ID ACRONYM DATA ---------- ----------- -------- 1 myAttribute myValue1
BEGIN p_externalapi.addProductAttribute(1, 'myAttribute', 'myValue2'); END; /
SQL> select product_id, acronym, data from external_product_attributes_vw;
PRODUCT_ID ACRONYM DATA ---------- ----------- -------- 1 myAttribute myValue2
|