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.