Reference Manual
   CHAPTER 9. SQL Statements     

RESIGNAL statement

Function 

Resignal an exception condition.

Syntax 

RESIGNAL [ exception-name ]

Permissions 

None.

Side effects 

None.

See also 

SIGNAL statement

BEGIN... END statement

Using exception handlers in procedures and triggers

RAISERROR statement

Description 

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 will be handled by another exception handler or returned to the application. Any actions by the exception handler before the RESIGNAL are undone.

Standards and compatibility 

• SQL/92     Persistent stored module feature.

• Sybase     Not supported in Adaptive Server Enterprise. Error handling in Transact-SQL procedures is carried out using the RAISERROR statement.

Example 

• 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 ;