Error Handling for Stored Procedures
There are three primary methods for trapping ORACLE errors that are returned from the kernel during the processing of your PL/SQL code:
- checking DBMS_ERROR_TEXT and DBMS_ERROR_CODE Built-in subprograms within
a form-level ON-ERROR trigger
- creating appropriate user-defined exceptions
- evaluating the SQLCODE and SQLERRM functions in a WHEN OTHERS exception
handler
Related topics
About using PL/SQL exception handling in triggers
About trigger failure results
About evaluating the success or failure of Built-ins
Checking DBMS_ERROR_TEXT and DBMS_ERROR_CODE