ALTER EXCEPTION

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

Advance To:

• ALTER INDEX