RE: resume on Exception
- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
- To: "'bobmetelsky@xxxxxxxxxxx'" <bobmetelsky@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 11:13:07 -0400
while <condition>
begin
update xxx where recnum ... ;
exception
when others write rrno & recnum to file and continue;
end;
end loop;
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Bob Metelsky [mailto:bobmetelsky@xxxxxxxxxxx]
> Sent: Friday, October 15, 2004 11:07 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: resume on Exception
>
>
> 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."
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
