RESIGNAL Statement

Quick Links:

Syntax

RESIGNAL [ exception-name ]

Examples

(back to top)

Example 1 – this code fragment returns all exceptions except for “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 ;

Usage

(back to top)

Within an exception handler, RESIGNAL lets you quit the compound statement with the exception still active, or 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.

Standards

(back to top)

SQL—ISO/ANSI SQL compliant.
SAP Sybase Database product—Not supported in Adaptive Server. Error handling in Transact-SQL procedures is carried out using the RAISERROR statement.

Permissions

(back to top)

None