Mega Code Archive
This script demonstrates the scope of exceptions
<![CDATA[
SQL>
SQL> BEGIN
2 DECLARE
3 myException EXCEPTION;
4 BEGIN
5 RAISE myException;
6 END;
7 EXCEPTION
8 WHEN OTHERS THEN
9 RAISE;
10 END;
11 /
BEGIN
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of RNTSOFT.LOG_ERRORS
ORA-01031: insufficient privileges
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 9
SQL>
SQL> CREATE OR REPLACE PACKAGE Globals AS
2 myException EXCEPTION;
3 END Globals;
4 /
Package created.
SQL>
SQL> BEGIN
2 BEGIN
3 RAISE Globals.myException;
4 END;
5 EXCEPTION
6 WHEN Globals.myException THEN
7 RAISE;
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of RNTSOFT.LOG_ERRORS
ORA-01031: insufficient privileges
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 7
SQL>
]]>