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?


"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."


Other related posts: