DeleteProductById

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   DeleteProductById

Procedure body DeleteProductById(productId NUMBER), Package PRODUCTS

Name	Datatype	Precision	Description
productId	NUMBER		NUMBER, parameter of PRODUCTS.DeleteProductById

procedure DeleteProductById( productId   in NUMBER )
    is
    begin
        DELETE PRODUCT where id = productId;
		COMMIT;
    end DeleteProductById

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCT	Table	Table
<DEFAULT SCHEMA>.PRODUCTS.DeleteProductById	Procedure	Procedure interface DeleteProductById(productId NUMBER), Package PRODUCTS
NUMBER	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.PRODUCT.ID	Primary Key	Column