IN PL/SQL

In your assignment file that you submit, first, place the code needed to create the procedure. After that, skip a few lines and there include the anonymous block code to call the procedure.

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 at each stage of the order process are 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# = XW2384YXK4957