APEX

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!

Capture "ORA-00001:Unique Constraint error and display user-friendly messag

586040Jul 8 2008 — edited Jul 14 2008

Hello,

I would like to be able to show a user-friendly inline message when I encounter an "ORA-0001:Unique Constraint" error. I have done some research. One solution creates a separate error page but unfortunately removes all session variables. Another requires that an installation must be done on the surver but the DBA/ Server Admin is busy with something else. Yet another shows me how to create a table to capture the ora error but when I retreive it, I don't know how to retreive the correct error that was just captured in the table.

Can someone please give me step-by-step directions on how to set up simple error-handeling that brings up a user-friendly inline message?

Why is validation in APEX so difficult? Or maby I'm just missing something?

Help!

leh

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2008

Added on Jul 8 2008

#apex-discussions

12 comments

8,201 views