catch DML exceptions in ETL process

[doraemona]

Hi

I wonder if anyone know how to catch DML exceptions in an ETL process


For example this code

begin
   for i in (Select * from dept)
   loop
      begin
         delete emp where deptno = i.deptno;
         commit;
      exception
      when others then
         dbms_output.put_line('ERROR: ' || i.deptno);
      end;
   end loop;
end;
/

this is easy since we process row by row but how can we catch the error if we use FORALL/BULK?

How about PRO*C (possibility of doing this?)

Cheers

[slimdave]

http://asktom.oracle.com/pls/ask/f?p...3675533064673,

[doraemona]

Hi Slimdave


I cant see any thing related to this problem in that URL? If you mean SAVE EXCEPTIONS since I am using 8i I cant use it

[tamilselvan]

You can capture exception even with FORALL/BULK COLLECT.

Tamil

[doraemona]

Hi Tamil

I think its possible with 9i but not in 8.1.7.4!