10 Replies Latest reply on Dec 31, 2012 9:01 AM by 920719

    How to Catch Database exception in form

      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