Skip to Main Content

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!

How to raise anpplication error

672792Nov 28 2008 — edited Nov 30 2008
hi ,

I need to raise user defined error like 10001.So how to raise this error through procedure.


select field1,field2...from table_name;

if no data is there, then it raise no_data_found.
but i need to send 10001.

This is the problem i am facing.


rasie_application_error('10001','') is it equivalent to raise exception 10001(in INFORMIX).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2008
Added on Nov 28 2008
9 comments
565 views