SIGNAL

---

Raises the specified exception condition.

Usage

Procedural.

Description

The SIGNAL statement has the effect of raising an exception condition specified by an SQLSTATE value or a condition name.

If a condition identifier is used in the statement the associated SQLSTATE value is raised. If the condition identifier is declared without a SQLSTATE value, the SQLSTATE 45000 is raised. If there is an appropriate exception handler for this SQLSTATE, this handler will be invoked otherwise the SQLSTATE is propagated to the calling environment.

Note that a SQLSTATE value corresponding to a warning condition that is not catched by an exception handler will not be propagated to the calling environment.

Notes

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

Example

 SIGNAL SQLSTATE 'UE456';
 

For more information, see the Mimer SQL Programmer's Manual, SIGNAL Statements.

Standard Compliance

Standard	Compliance	Comments
SQL-99	Non core extensions	Feature P002, "Computational completeness".

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se