That's exactly what you have to do. Once an error is encountered it
will go to the next exception handler and use that and exit out of the
block. If only one exception handler is in your code it will exit out
of the program. By embedding it, you will exit out of that anonymous
block and continue with the remaining code..
-----Original Message-----
From: Adams Scott D. - G6
[mailto:oracledba-ezmlmshield-x9901839.[Email address protected]
Sent: Tuesday, November 01, 2005 11:23 AM
To: LazyDBA Discussion
Subject: RE: PL/SQL Exception
I have that at the bottom of my procedure now. I was just reading the
docs
and it mentioned enclosing the portion of the procedure that may cause
that
error inside its own begin/end. Does that make sense?
Scott D. Adams
Database Administrator
FORSCOM, G6
scott.[Email address protected]
(404) 464-5833
DSN 367-5833
-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x94600397.[Email address protected]
Sent: Tuesday, November 01, 2005 12:19 PM
To: LazyDBA Discussion
Subject: RE: PL/SQL Exception
BEGIN
SELECT ... INTO ...
EXCEPTION
WHEN no_data_found THEN
NULL;
END;
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Adams Scott D. - G6
[mailto:oracledba-ezmlmshield-x5634318.[Email address protected]
Sent: Tuesday, November 01, 2005 12:15 PM
To: LazyDBA Discussion
Subject: PL/SQL Exception
I have a procedure that has a section that could possibly return no data
found error. This is ok and expected. I would like to handle this in
the
exception portion of my procedure. I would like it to ignore that error
and
continue with the procedure. Any help would be greatly appreciated.
Scott D. Adams
Database Administrator
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
NOTICE:
The information contained in this electronic mail transmission is intended by Monster Worldwide, Inc. or one of its subsidiaries or affiliated companies for the use of the named individual or entity to which it is addressed and may contain information that is privileged or otherwise confidential. It is not intended for transmission to, or receipt by, any individual or entity other than the named addressee (or a person authorized to deliver it to the named addressee) except as otherwise expressly permitted in this electronic mail transmission. If you have received this electronic transmission in error, please delete it without copying or forwarding it, and notify the sender of the error by reply email. (FE01)
Oracle LazyDBA home page