Question: In PL/SQL, I need to add error handling or an exception block to the following insert_items procedure that writes errors to the nc_error table: /*

In PL/SQL, I need to add error handling or an exception block to the following insert_items procedure that writes errors to the nc_error table:

/* Create draft insert_items procedure. */ CREATE PROCEDURE insert_items ( pv_items ITEM_TAB ) IS BEGIN /* Read the list of items and call the insert_item procedure. */ FOR i IN 1..pv_items.COUNT LOOP insert_item( pv_item_barcode => pv_items(i).item_barcode , pv_item_type => pv_items(i).item_type , pv_item_title => pv_items(i).item_title , pv_item_subtitle => pv_items(i).item_subtitle , pv_item_rating => pv_items(i).item_rating , pv_item_rating_agency => pv_items(i).item_rating_agency , pv_item_release_date => pv_items(i).item_release_date ); END LOOP; END; /

How do I do this?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!