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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!