RESIGNAL statement
590
RESIGNAL statement
Use this statement to resignal an exception condition.
RESIGNAL [
exception-name
]
None.
None.
"SIGNAL statement" on page 619
"BEGIN statement" on page 404
"Using exception handlers in procedures and triggers" on page 479 of the
book ASA User’s Guide
"RAISERROR statement" on page 584
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.
♦
SQL/92 Persistent stored module feature.
♦
Sybase Not supported in Adaptive Server Enterprise. Signaling of
errors in Transact-SQL procedures is carried out using the RAISERROR
statement.
♦ 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;
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example
To Next Page
Loading...