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!

SQLERRM in Exception Handling

user533016Jul 4 2008 — edited Jul 4 2008
Hi

I have used the SQLERRM in a PL/SQL block. Though it returns the error message but thats not the entire message. It truncates some text and displays only 24 characters.

can anyone suggest how to get the entire message?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2008
Added on Jul 4 2008
10 comments
1,409 views