Adding User-Defined Exceptions : User Defined Exceptions « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. User Defined Exceptions

Before raising a user-defined exception, you must first declare the exception.

The syntax is

<exception_name> exception;

When you raise the exception, you do it by using the RAISE command.

The syntax is:

raise <exception_name>;

Handle your exception just as if it were a named predefined exception. The syntax is:

when <exception_name> then