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.