The Firebird 5.0 Language Reference | DROP EXCEPTION

`DROP EXCEPTION` Examples

Dropping exception E_LARGE_VALUE

DROP EXCEPTION E_LARGE_VALUE;

`RECREATE EXCEPTION`

Drops a custom exception if it exists, and creates a custom exception

Available in

DSQL

Syntax

RECREATE EXCEPTION exception_name '<message>'

!! See syntax of CREATE EXCEPTION for further rules !!

The statement RECREATE EXCEPTION creates a new exception for use in PSQL modules.If an exception with the same name exists already, the RECREATE EXCEPTION statement will try to drop it and create a new one.If there are any dependencies on the existing exception, the attempted deletion fails and RECREATE EXCEPTION is not executed.

`RECREATE EXCEPTION` Example

Recreating the E_LARGE_VALUE exception

RECREATE EXCEPTION E_LARGE_VALUE
  'The value exceeds its limit';

DROP EXCEPTION Examples

DROP EXCEPTION Examples

RECREATE EXCEPTION

RECREATE EXCEPTION Example

`DROP EXCEPTION` Examples

`RECREATE EXCEPTION`

`RECREATE EXCEPTION` Example