Deletes an external product.
Input
Parameter | Type | Description |
|---|---|---|
v_product_id | NUMBER | The id of the product to be deleted |
Example
select product_id, product_name from external_product_vw;
PRODUCT_ID PRODUCT_NAME ---------- --------------------- 98 Test External Product 99 Other External Product
BEGIN p_externalapi.deleteProduct(99); END; /
select product_id, product_name from external_product_vw;
PRODUCT_ID PRODUCT_NAME ---------- --------------------- 98 Test External Product |