Insert as select, capture errors

[rigatoni]

I WilliamR's suggestion is to use PL/SQL and loop through a cursor catching any errors that occur inside the loop.

Something like:

begin

for r1 in (SELECT DISTINCT
0098 .....
FROM PROD.LOADER_EV200)
loop

begin

insert into ....
values (...);

exception
when ...
then

-- log error or something
end;

end loop;


end;