From InterBase

Go Up to Statement and Function Reference (Language Reference Guide)

Changes the message associated with an existing exception. Available in DSQL and isql, but not in the embedded language or stored procedure and trigger language.

ALTER EXCEPTION name 'message'
Argument Description


Name of an existing exception message


Quoted string containing ASCII values

Description: ALTER EXCEPTION changes the text of an exception error message.

An exception can be altered by its creator, the SYSDBA user, and any users with operating system root privileges.

Example: This isql statement alters the message of an exception:

ALTER EXCEPTION CUSTOMER_CHECK 'Hold shipment for customer

See Also

Advance To: