avoid declaration exception for default value : Default Value « PL SQL « Oracle PL / SQL






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

1.using the DEFAULT keyword to assign a value to a variable:
2.Assign default value