Oracle PL/SQL - PL SQL Statement Exception attributes

Introduction

An exception has four attributes:

Attribute Description
Name provides a short description of the problem.
Type identifies the area of the error.
Exception Code a numeric representation of the exception.
Error message information about the exception.

For example, the predefined divide-by-zero exception has the following values for the attributes:

Attribute Description
Name ZERO_DIVIDE
Type ORA (Oracle engine)
Exception Code ?01476
Error message divisor is equal to zero

Related Topic