602SQL Documentation Index  

RESIGNAL Statement

statement_RESIGNAL ::= RESIGNAL [ exception_identifier ];

This statement passes the specified exception or the exception that is currently being processed (if no exception_identifier is set) to the outer handler for processing. If a handler is declared for this exception outside of the current handler, the handler is executed and statement execution continues according to the handler type.

The RESIGNAL statement may only be used inside an exception handler, or the error sqlstate OK000 (SQ_RESIGNAL_HND_NOT_ACT) occurs.

If no handler is found for the specified exception, the error sqlstate 45000 (SQ_UNHANDLED_USER_EXCEPT) occurs.

See