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





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: