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 do I display only raise_application_error message

516873Mar 7 2007 — edited Mar 8 2007

I am using the following within a trigger:

raise_application_error(-20000, 'Relationship start date must be before hire date', FALSE);

I just want to display - ORA-20000 Relationship start date must be before hire date

but what actually displays is...

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.FND_MESSAGE", line 219 ORA-06512: at "APPS.HR_PROCESS_CONTACT_SS", line 9123 ORA-20000: Relationship start date must be before hire date ORA-06512: at "APPS.DRM_BEN_REL_DATE_SS", line 24 ORA-04088: error during execution of trigger 'APPS.DRM_BEN_REL_DATE_SS' ORA-06512: at line 1

How can I single out the error message that I want to call and leave out the rest?

Thanks in advance

-M

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2007

Added on Mar 7 2007

6 comments

1,100 views