resume on Exception

  • From: Bob Metelsky <bobmetelsky@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 15 Oct 2004 11:06:45 -0400

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

Other related posts: