Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PUTTING NULL after NO_DATA_FOUND exception

825873Dec 29 2010 — edited Dec 29 2010
hi,

Can we put null;
after not_data_found exception?

I dont want to find any error due to no_data_found instead I want the proc to continue like that without giving any validations.

BEGIN
-------PROC code here------
EXCEPTION
WHEN NO_DATA_FOUND
THEN
NULL;
END;

I have put the exception like above. is it correct way. Or will I face any error due to that.??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2011
Added on Dec 29 2010
#exception
7 comments
4,232 views