Hello,
I have made an event that throws an error message to the user, using the error_sys.record_general function, based on some criteria set in the event, which triggers on a change in the status of the object.
error_sys.record_general( 'SomeLogicUnit', 'SOMEERRORMSG: this is an error message');I am in the process of creating another event that will change the status of the object, but I am wondering if it is possible to catch the exception raised in the other event, and handle it separately?
Without handling the event, and running the event manually in a DBMS, the procedure completes, but returns
ORA-20110: SomeLogicUnit.SOMEERRORMSG: this is an error message
My event would look something like this:
BEGIN
--change status on object, which may cause an error to be raised in the other event
EXCEPTION
WHEN ... THEN
-- handle the exception raised from the other event
END;If I specify “EXCEPTION WHEN others THEN … “ I will catch the error raised in the other event, but I won’t know the source of the error, or the error itself for that matter. Is there a way for me to handle that specific error, or would I have to declare and raise the error in the source event manually?
