hi oracle lovers
my question is
how can i ignore the error in a pl/sql code and continue with the processing of the code which follows the error line.
i mean to say if there are n statements to be processed and if
i get an error in a line some where in the statement 10 ,i have to ignore the statement 10 and continue with the processing from 11 to n


thr

hi,

Try using Exception block, you will get what you want.



Ram

try,

.......
-- statement no 9
begin
  -- Your statement no 10.
exception
  when others then
  null;
end;
-- Statement no 11.

Sujit Ku. Mahapatra