avoid declaration exception
SQL>
SQL>
SQL> declare
2 myNumber number;
3 begin
4 myNumber := 'MY NUMBER';
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 8
SQL>
Related examples in the same category