RE: resume on Exception

From: "Weiss, Rick" <rweiss@xxxxxxxxxxx>
To: <bobmetelsky@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 15 Oct 2004 09:15:09 -0600

Bob:

I'm pretty rusty on it, but the basics are:

WHILE foo
 LOOP

   UPDATE xxx
      SET col1 =3D ***
    WHERE conditions;

   EXCEPTION
    WHEN OTHERS
     THEN
      Your error handling code here
   END;

   Any other in LOOP code here.

END LOOP;

As I said, it has been some time since I've done this, but I'm sure my =
oversights will be promptly corrected.

Rick Weiss

Oracle Database Administrator
Technical Services Bureau
Central Services Division
MT Dept of Labor & Industry

Phone: (406) 444-9628
E-Mail: rweiss@xxxxxxxxxxx


-----Original Message-----
From: Bob Metelsky [mailto:bobmetelsky@xxxxxxxxxxx]
Sent: Friday, October 15, 2004 9:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: resume on Exception=20


All, I know I can trap and exit on an exception but how can the program=20
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

--=20
"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

RE: resume on Exception

Other related posts: