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