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!

Needs to trim error code

Uzair Hasan NizamiJun 10 2011 — edited Jun 10 2011
Hi All,


BEGIN
raise_application_error (-20004, 'There is an error' , TRUE);
END;

Will raise an error, mentioned below

ORA-20004: There is an Error
ORA-06512: at line 3



Now I need to show only *"There is an Error"* . I dont want to show the error no.

Please help me to resolve this issue.

Thanks & Regards
Uzair Hasan Nizami
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2011
Added on Jun 10 2011
3 comments
202 views