SQL>
SQL> -- when others then
SQL>
SQL> set serverout on
SQL>
SQL> declare
2 PARENT_ERROR exception;
3 begin
4 declare
5 CHILD_ERROR exception;
6 begin
7 raise CHILD_ERROR;
8 exception
9 when CHILD_ERROR then
10 dbms_output.put_line('nested block exception handler');
11 raise;
12 end;
13 exception
14 when PARENT_ERROR then
15 dbms_output.put_line('parent block exception handler');
16
17 when OTHERS then
18 dbms_output.put_line('Caught the OTHERS exception');
19 raise;
20
21 end;
22 /
nested block exception handler
Caught the OTHERS exception
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 19