CREATE OR ALTER EXCEPTION
Example
Changing the message for the exception
E_LARGE_VALUE
CREATE OR ALTER EXCEPTION E_LARGE_VALUE
'The value is higher than the permitted range 0 to 32,765';
CREATE OR ALTER EXCEPTION
ExampleE_LARGE_VALUE
CREATE OR ALTER EXCEPTION E_LARGE_VALUE
'The value is higher than the permitted range 0 to 32,765';
DROP EXCEPTION
Drops a custom exception
DSQL, ESQL
DROP EXCEPTION exception_name
Parameter | Description |
---|---|
exception_name |
Exception name |
The statement DROP EXCEPTION
is used to delete an exception.Any dependencies on the exception will cause the statement to fail, and the exception will not be deleted.
The DROP EXCEPTION
statement can be executed by:
The owner of the exception
Users with the DROP ANY EXCEPTION
privilege
DROP EXCEPTION
ExamplesE_LARGE_VALUE
DROP EXCEPTION E_LARGE_VALUE;