resume on Exception

From: Bob Metelsky <bobmetelsky_at_comcast.net>
Date: Fri, 15 Oct 2004 11:06:45 -0400
Message-ID: <416FE785.3090903@comcast.net>

All, I know I can trap and exit on an exception but how can the program trap and continue?

say I have

while <condition>

       update xxx where recnum ... ;
            if  any_exception then
                write any_exception & recnum to file and continue;
            end if;

end loop;

any examples of this logic?

Thanks!
Bob

-- 
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 15 2004 - 10:02:21 CDT