avoid declaration exception for default value
SQL>
SQL>
SQL> begin
2 declare
3 myNumber 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 /
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