How to define your own exception : Your own Exception « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Your own Exception

How to define your own exception

SQL>
SQL>
SQL> -- User defined exception
SQL>
SQL>  begin
  2      declare --start of nested block
  3        NESTED_EXCEPTION exception;
  4      begin
  5        raise NESTED_EXCEPTION;
  6      end; --end of nested block
  7    exception
  8      when NESTED_EXCEPTION then
  9        dbms_output.put_line('NESTED_EXCEPTION caught!');
 10    end;
 11    /
    when NESTED_EXCEPTION then
         *
ERROR at line 8:
ORA-06550: line 8, column 10:
PLS-00201: identifier 'NESTED_EXCEPTION' must be declared
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated


SQL>
SQL>








Related examples in the same category

1.Define and use your own exception
2.used defined exception
3.Using SQLCODE and SQLERRM
4.Handling a user-defined exception
5.Raise User-defined exceptions
6.Insert Exception message to an audit table