http://developer.mimer.com

RESIGNAL

---

Raises the current, or the specified, exception condition.

Usage

Procedural.

Description

The RESIGNAL statement has the effect of raising the current exception condition, if specified without an argument, or an alternative exception condition specified by either an SQLSTATE value or a condition name.

Restrictions

The RESIGNAL statement 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.

Notes

See DECLARE CONDITION for a description of how to declare a condition name.

Example

 RESIGNAL SQLSTATE 'UE456';
 

For more information, see the Mimer SQL Programmer's Manual, chapter 12, RESIGNAL Statements.

Standard Compliance

Standard	Compliance	Comments
SQL/PSM	YES	Fully compliant.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se