12 PL/SQL Error Handling

This chapter explains how to handle PL/SQL compile-time warnings and PL/SQL runtime errors. The latter are called exceptions.

Note:

The language of warning and error messages depends on the NLS_LANGUAGE parameter. For information about this parameter, see Oracle Database Globalization Support Guide.

Topics

• Compile-Time Warnings

• Overview of Exception Handling

• Internally Defined Exceptions

• Predefined Exceptions

• User-Defined Exceptions

• Redeclared Predefined Exceptions

• Raising Exceptions Explicitly

• Exception Propagation

• Unhandled Exceptions

• Retrieving Error Code and Error Message

• Continuing Execution After Handling Exceptions

• Retrying Transactions After Handling Exceptions

• Handling Errors in Distributed Queries

See Also:

• "Exception Handling in Triggers"

• "Handling FORALL Exceptions After FORALL Statement Completes"

Tip:

If you have problems creating or running PL/SQL code, check the Oracle Database trace files. The DIAGNOSTIC_DEST initialization parameter specifies the current location of the trace files. You can find the value of this parameter by issuing SHOW PARAMETER DIAGNOSTIC_DEST or query the V$DIAG_INFO view. For more information about diagnostic data, see Oracle Database Administrator’s Guide.