Inner exception and outter exception

 


SQL>
SQL> -- Inner exception and outter exception
SQL>
SQL>
SQL>  begin
  2      declare
  3        l_number number default 'MY NUMBER';
  4      begin
  5        null;
  6      exception
  7        when OTHERS then
  8          dbms_output.put_line('Exception caught in inner block');
  9      end;
 10    exception
 11      when others then
 12        dbms_output.put_line('Exception caught in outer block');
 13        raise;
 14    end;
 15    /
Exception caught in outer block
 begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 13


SQL>

Related examples in the same category

1.	Exception Range in action
2.	Add a WHEN OTHERS handler to catch all runtime exceptions.
3.	A WHEN OTHERS handler that records which runtime error occurred.
4.	Raising a dynamic exception without previously declaring a user-defined EXCEPTION variable:

Inner exception and outter exception : Exception Range « PL SQL « Oracle PL / SQL

Related examples in the same category