Embed the sql into a pl/sql block with the exception handler.

Ex//

...
Begin
Select x into v1 from XXXX;
Exception
When no_data_found then
Null;
End;
...


-----Original Message-----
From: Adams Scott D. - G6
[mailto:oracledba-ezmlmshield-x5634318.[Email address protected]
Sent: Tuesday, November 01, 2005 11:15 AM
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



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. (FE2)

Oracle LazyDBA home page