Problem with exception handling

From: Ivan Bajon <ib_at_ed.dk>
Date: Fri, 17 Jul 1998 13:47:37 +0200
Message-ID: <6ondee$95k$1@news1.tele.dk>

I'm trying to make a procedure resume after an exception has been raised. The situation is more or less like this:

procedure My Proc;
begin

    for c1rec in c1 loop
/* c1 is my cursor */

        insert into sometable c1rec.somefield;
        commit;

    end loop;
    exception

        when others do
            insert into errortable 'Some error message';

end;

Lets say c1 yields 1000 records and that an exception occur in the 500th insert. How do I make it resume and do the last 500 inserts after handling the exception?

Any help appreciated.
- Ivan Bajon NOCP (Not Oracle Certified Professional) Received on Fri Jul 17 1998 - 06:47:37 CDT