Hi,
I need some idea/ concept regarding how to setup exception handling mechanism where all the oracle error , that shows the name of different objects used and the error codes should be replaced with some generic error message some of the most errors encountered by the application.
example
- ORA-02437: cannot validate <object_name> - primary key violated
should be replace by something like this - YOU HAVE VIOLATED UNIQUENESS IN YOUR USER LIST.
The application is designed in Oracle Apex, using oracle PL/SQL.
I would like to trap -
1. Oracle apex errors
2. User defined errors
3. Errors generated during the use of database objects like constraint violation,
4. Oracle internal system errors not required .. like SGA, tablespace.. etc
Apart from changes in the database , what changes needed in the Apex pages like do we need to change in every apex page or is there any way we create a page and then redirect all the errors to that page .. or is there any other better way out. How can we achieve this ?
Thanks in advance