DeleteOrderItemById


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER   >   DeleteOrderItemById   

Procedure body DeleteOrderItemById(orderId NUMBER), Package SALEORDER

Name Datatype Precision Description
orderId NUMBER NUMBER, parameter of SALEORDER.DeleteOrderItemById
Name Types Value
No Data
Name Definition
No Data

procedure DeleteOrderItemById( orderId   in NUMBER )
    is
    begin
         DELETE sales_order_items where id = orderId;
		COMMIT;
    end DeleteOrderItemById

     
Name Types Description
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS Table Table
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderItemById Procedure Procedure interface DeleteOrderItemById(orderItemId NUMBER), Package SALEORDER
NUMBER PL/SQL System type PL/SQL System Object
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.ID Primary Key Column

     
No Data