1. For the following stored procedure, please fill in the missing information in the underlined areas:

For the following stored procedure, please fill in the missing information in the

underlined areas:

create or replace procedure get_items_shipped_capt as

cursor list_items(cid in captain.capt_id%type) is

select item.item_no, ,weight

from item,shipment_line,shipment

where item.item_no =

and shipment_line.shipment_id = shipment.shipment_id

and shipment.capt_id =;

cursor all_captains is

select capt_id from captain;

TB constant char(1) := CHR(9);

begin

for cp inloop dbms_output.put_line(Captain ID: '||cp.capt_id); dbms_output.new_line;

dbms_output.put_line('Item Number'||TB||'Description'||TB||'Weight');

dbms_output.put_line('=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

=+=+');

for det in list_items() loop

dbms_output.put_line(det.item_no||TB||det.description||TB||

det.weight);

end loop; dbms_output.new_line; end loop;

end;