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!

SQLERRM and User Defined Exceptions in PL/SQL

David PulliamAug 28 2008 — edited Aug 28 2008
Ok here is the question. I am writing procedures for APEX in which I have found the need to use exceptions I define and raise myself. However, I want to manually control SQLERRM for those exceptions to assign it a meaningful message so that I can just show the SQLERRM in APEX. I don't want to reassign it to another ORA code, I just want to manually tell the exception what to return for SQLERRM instead of returning a pre-defined ORA error or just returning 'User Defined Exception'.

Can this be done and how?

I have been looking through information that I have and I have yet to find anything on how to set the sqlerrm text for a user defined exception.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2008
Added on Aug 28 2008
#apex, #exception, #plsql, #sql
4 comments
1,047 views