Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to raise an exception in procedure

User_FZOVQMay 16 2022

Hi,
I am working to create a procedure in which is to raises an exception if the time is not between 7am and 6pm. Below is what I tried and I wonder what do I need in there in order to raise an exception? Thanks for your advice!
CREATE OR REPLACE PROCEDURE SECURE_ROWS AS
BEGIN
NULL;
END SECURE_ROWS;

Comments
Post Details
Added on May 16 2022
2 comments
289 views