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: