Creating Exceptions

Go Up to Stored Procedure Exceptions

To create an exception, use the following CREATE EXCEPTION syntax:

CREATE EXCEPTION name '<message>';

For example, the following statement creates an exception named
REASSIGN_SALES:

CREATE EXCEPTION REASSIGN_SALES 'Reassign the sales records
 before deleting this employee.';