Raises the specified exception condition.
where signal-information is:
SIGNALstatement has the effect of raising an exception condition specified by an
SQLSTATEvalue 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 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.
It is possible to provide diagnostics information with the signal statement. This diagnostics information can be retrieved where the exception is handled. This can be used to customize error messages for an application. The signal-information fields are described in the GET DIAGNOSTICS section condition-info Information Items.
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.
See DECLARE CONDITION for a description of how to declare a condition name.
Examplesignal sqlstate 'UE324' set message_text = 'A horse named ' || horse_name || ' already exists in the database';
For more information, see the Mimer SQL Programmer's Manual, SIGNAL Statements.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40