declaration exception
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>