ALTER EXCEPTION

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>

Name of an existing exception message

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
remittance.';

See Also

Advance To: