meta data for this page
  •  

RECREATE EXCEPTION

Available in: DSQL

Added in: 2.0

Description

Creates or recreates an exception. If an exception with the same name already exists, RECREATE EXCEPTION will try to drop it and create a new exception. This will fail if there are existing dependencies on the exception.

Syntax

Exactly the same as CREATE EXCEPTION.

Note: If you use RECREATE EXCEPTION on an exception that has dependent objects, you may not get an error message until you try to commit your transaction.