Oracle PL/SQL - PL SQL Statement Exception Types

Introduction

Exceptions are identified by type, code, name, and error message.

Exception types can be identified by the error code prefixes as outlined in the following table.

Exception codes are negative and are always displayed with five digits.

The code, along with the exception type, uniquely defines the exception.

The Oracle function SQLCODE returns the type and code of the most recently raised exception.

Exception names are associated with exceptions that you create yourself.

If the exception is named, you can use its name in the exception handler.

The exception message is a text string that describes the exception.

The function SQLERRM returns the text of the error message for the most recently raised exception.

Related Topic

• Exception
• Exception attributes
• Adding Exception Handlers to Your Code
• Predefined Exceptions in PL/SQL Code
• Handling an Unnamed Exception
• Assigning a Name to Predefined Exception Code
• User-Defined Exceptions
• Assigning a code to a user-defined exception
• Including error messages in user-defined exceptions
• Handle several exceptions
• Handling exceptions without halting the program
• Exceptions Raised in the Exception Handler

• Previous
• Next