This script demonstrates the scope of exceptions. : Predefined Exceptions « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Predefined Exceptions

This script demonstrates the scope of exceptions.

    
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 JAVA2S.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 JAVA2S.LOG_ERRORS
ORA-01031: insufficient privileges
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 7


SQL>








Related examples in the same category

1.Predefined exceptions: WHEN ZERO_DIVIDE
2.If an ordering is applied, it occurs after the WHERE has been executed
3.NO_DATA_FOUND Exception
4.This script demonstrates user defined exceptions
5.This block illustrates the behavior of a predefined exception