Who Can Create an Exception
The CREATE EXCEPTION
statement can be executed by:
-
Users with the
CREATE EXCEPTION
privilege
The user executing the CREATE EXCEPTION
statement becomes the owner of the exception.
The CREATE EXCEPTION
statement can be executed by:
Users with the CREATE EXCEPTION
privilege
The user executing the CREATE EXCEPTION
statement becomes the owner of the exception.
CREATE EXCEPTION
ExamplesE_LARGE_VALUE
CREATE EXCEPTION E_LARGE_VALUE
'The value is out of range';
E_INVALID_VALUE
CREATE EXCEPTION E_INVALID_VALUE
'Invalid value @1 for field @2';
ALTER EXCEPTION
Alters the default message of a custom exception
DSQL, ESQL
ALTER EXCEPTION exception_name '<message>'
!! See syntax of CREATE EXCEPTION
for further rules !!
The ALTER EXCEPTION
statement can be executed by:
The owner of the exception
Users with the ALTER ANY EXCEPTION
privilege