when other then not user-defined exception
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