RE: resume on Exception

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Fri, 15 Oct 2004 11:13:07 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA314E273B9@EXCHANGE>

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_at_comcast.net] 

> Sent: Friday, October 15, 2004 11:07 AM

> To: oracle-l_at_freelists.org

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

> 

> --

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

> 

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

Received on Fri Oct 15 2004 - 10:08:47 CDT