This discussion is archived
10 Replies Latest reply: Dec 31, 2012 1:01 AM by 920719 RSS

How to Catch Database exception in form

920719 Newbie
Currently Being Moderated
Hi Friends,
I have a table which has a unique constraint on couple of columns. I have created a form on this table. When I enter two similar items in those columns then the unique constraint should fire. This seems to happen as I am not able to save the form. But this exception is thrown by the database during the time of commit. How can I catch this exception. I have a function in the forms that does all the validation and at the end it issues a COMMIT_FORM.

Should I catch this in any trigger. Any hints please

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points