Altering Exceptions

Go Up to Stored Procedure Exceptions

To change the message returned by an exception, use the following syntax:

ALTER EXCEPTION name '<message>';

Only the creator of an exception can alter it. For example, the following statement changes the text of the exception created in the previous section:

ALTER EXCEPTION REASSIGN_SALES 'Can’t delete employee--Reassign
 Sales';

You can alter an exception even though a database object depends on it. If the exception is raised by a trigger, you cannot drop the exception unless you first drop the trigger or stored procedure. Use ALTER EXCEPTION instead.