Exception

An exception declaration declares a user-defined exception.

You must raise a user-defined exception explicitly with either a RAISE statement or the DBMS_STANDARD.RAISE_APPLICATION_ERROR procedure. The latter lets you associate an error message with the user-defined exception.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

exception_declaration ::=

Semantics

exception_name

The name of the exception that you are declaring.

Examples

• Example 2-24, "Block with Multiple and Duplicate Labels"

• Example 5-35, "TRIM Method"

• Example 5-38, "Collection Exceptions"

• Example 6-40, "ROLLBACK Statement"

• Example 7-13, "Validation Checks Guarding Against SQL Injection"

• Example 8-1, "Declaring, Defining, and Invoking a Simple PL/SQL Procedure"

• Example 10-6, "Creating emp_admin Package"

• Example 11-3, "Anonymous Block with Exception Handlers"

• Example 11-6, "Scope of Exceptions"

• Example 11-12, "Reraising an Exception"

• Example 12-10, "Rollbacks with FORALL Statement"

• Example 12-11, "FORALL Statement and SQL%BULK_EXCEPTIONS"

Related Topics

In this chapter:

• "Exception Handler"

• "RAISE Statement"

In other chapters:

• "User-Defined Exceptions"

• "Exception Declarations"