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
- ALTER PROCEDURE
- ALTER TRIGGER
- CREATE EXCEPTION
- CREATE PROCEDURE
- CREATE TRIGGER
- DROP EXCEPTION
- Data Definition Guide