CARIS HPD : HPD® Server API : External Product Data : P_EXTERNALAPI : REMOVEPRODUCTATTRIBUTE
 

REMOVEPRODUCTATTRIBUTE

Removes all values of an attribute from an external product.

Input

Parameter

Type

Description

v_product_id

NUMBER

The id of the product to be edited.

v_acronym

VARCHAR2

The acronym of the attribute

Example

SQL> select product_id, acronym, data from external_product_attributes_vw;

PRODUCT_ID ACRONYM     DATA

---------- ----------- --------

         1 myAttribute myValue1

         1 myAttribute myValue2

BEGIN

    p_externalapi.removeProductAttribute(1, 'myAttribute');

END;

/

SQL> select product_id, acronym, data from external_product_attributes_vw;

no rows selected