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!

Oracle Exception handling

614921Nov 21 2008 — edited Dec 23 2008
We are doing like this in Our Stored Procedure

EXCEPTION WHEN OTHERS THEN
raise_application_error(SQLCODE, SQLERRM);

and there was a comment from the testing Team

raise_application_error(SQLCODE, SQLERRM) for error handle is not correct. All error out of range of -20000 to -20999 will encounter another error as ORA-21000: error number argument to raise_application_error of -1400 is out of
range
So can anyone tell us exctly that how to Do this.


Our requirement is that we want to log the Exact error msg and Code.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2009
Added on Nov 21 2008
16 comments
3,432 views