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 |
---|