Create a procedure named statusshipsp that allows an


Create a procedure named STATUS_SHIP_SP that allows an employee in the Shipping Department to update an order status to add shipping information.

The BB_BASKETSTATUS table lists events for each order so that a shopper can see the current status, date, and comments as each stage of the order process is finished.

The IDSTAGE column of the BB_BASKETSTATUS table identifies each stage; the value 3 in this column indicates that an order has been shipped. The procedure should allow adding a row with an IDSTAGE of 3, date shipped, tracking number, and shipper.

The BB_STATUS_SEQ sequence is used to provide a value for the primary key column.

Test the procedure with the following information: Basket # = 3 Date shipped = 20-FEB-12 Shipper = UPS Tracking # = ZW2384YXK4957

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create a procedure named statusshipsp that allows an
Reference No:- TGS02239254

Now Priced at $20 (50% Discount)

Recommended (92%)

Rated (4.4/5)