Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

RESIGNAL statement

Use this statement to resignal an exception condition.

RESIGNAL [ exception-name ]

Within an exception handler, RESIGNAL allows you to quit the compound statement with the exception still active, or to quit reporting another named exception. The exception is handled by another exception handler or returned to the application. Any actions by the exception handler before the RESIGNAL are undone.

None.

None.

• SIGNAL statement
• BEGIN statement
• Using exception handlers in procedures and triggers
• RAISERROR statement [T-SQL]

• SQL/2003    Persistent Stored Module feature.

The following fragment returns all exceptions except Column Not Found to the application.

...
DECLARE COLUMN_NOT_FOUND EXCEPTION
   FOR SQLSTATE '52003';
...
EXCEPTION
WHEN COLUMN_NOT_FOUND THEN
SET message='Column not found';
WHEN OTHERS THEN
RESIGNAL;