SQL>
SQL>
SQL> declare
2 myNumber number default 'MY NUMBER';
3 begin
4 null;
5 exception
6 when OTHERS then
7 dbms_output.put_line('Exception caught');
8 raise;
9 end;
10 /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 2
SQL>