declare
str varchar(2);
begin
str:='sa';
exception
when value_error then
dbms_output.put_line('invalid input');
end;
/
declare
str varchar(2);
begin
str:='sa';
exception
when value_error then
dbms_output.put_line('invalid input');
end;
/