Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information.
Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the user that an invalid Region_id is entered.
Remember to use the Sequence Store_seq to generate the StoreRoom_ID
July 8, 2008 7:04 AM
July 8, 2008 12:47 PM