A reader, November 05, 2017 - 10:42 am UTC
Given issue
ajit kulshrestha, November 17, 2017 - 9:10 am UTC
Always make a practice to initialize variable in Begin-end block for handling the exception .
ex :
create or replace procedure proc_delme
is
n number;
begin
n:=1/0;
dbms_output.put_line(n);
exception
when others then
dbms_output.put_line(sqlerrm);
end proc_delme;