Adds an attribute to an external product.
Note this does not replace any existing values so you can add multiple values for the same attribute.
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 |
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 myValue1 1 myAttribute myValue2 |