Raises the current, or the specified, exception condition.
RESIGNALstatement has the effect of raising the current exception condition, if specified without an argument, or an alternative exception condition specified by either an
SQLSTATEvalue or a condition name.
If a condition identifier is used in the statement the associated
SQLSTATEvalue is raised. If the condition identifier is declared without an
45000is raised. If there is an appropriate exception handler for this
SQLSTATE, this handler will be invoked otherwise the
SQLSTATEis propagated to the calling environment.
Note that an
SQLSTATEvalue corresponding to a warning condition that is not catched by an exception handler will not be propagated to the calling environment.
RESIGNALstatement may only be used within an exception handler, see DECLARE HANDLER, to force re-propagation of an exception condition to the scope or calling environment enclosing the scope supporting the exception handler.
See DECLARE CONDITION for a description of how to declare a condition name.
ExampleRESIGNAL SQLSTATE 'UE456';
For more information, see the Mimer SQL Programmer's Manual, RESIGNAL Statements.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40