I have a driver procedure that calls various other procedure which in turn calls other procedures.
I want to raise a highest level fatal exception when any DMl fails. This can happen in any of the inner or outer procedures i.e. i want to display an error message and stop all execution for this situation.
I am using the RAISE_APPLICATION_ERROR (-20102, 'Fatal Exception Occurred. Abormal Program Termination.'); for this purpose.
But since all my procedures handle exceptions, if this fatal exception is encountered in the inner procedures, it shows the application error and is then handled by the exception block of the calling procedure, which i dont want.
I want it to terminate everything the moment RAISE_APPLICATION_ERROR is called.
Is there any other way i can do it so that all processing is stopped once that function/procedure is called?
Also please let me know how to exit from the application by calling EXIT / QUIT from the procedure.
Quick responses will be highly appreciated.
Thanks in Advance,