3 Replies Latest reply on Jan 12, 2018 6:57 PM by Sven W.

    How to provide user friendly messages for ORA errors

    Sgodavar-Oracle

      I'm using APEX 5.1.1. I have a form with a bunch of fields and processes to insert and update the fields. Depending on the field values, some times I get some ORA errors as below. How can I handle them and display user friendly messages?. Also, I have text area field, which I try to set to max value the user can enter, but still accepts the large text. any ideas are appreciated, thanks.

       

      ORA-00001: unique constraint (stp.projects_uk) violated

       

      ORA-01400: cannot insert NULL into ("stp"."projects"."name")

       

      ORA-01461: can bind a LONG value only for insert into a LONG column