signal

SQL/PL

Signal a condition or exception

Syntax

signal_stmt:
          SIGNAL specific_condition [SET MESSAGE_TEXT = "string"]

Description

The SIGNAL statement is used to invoke the handler associated with the specified specific_condition. The MESSAGE_TEXT field of the GET DIAGNOSTICS area can be optionally SET to a text string value. This implementation is a subset of the SQL standard.

Example

create procedure nested_handler
begin
    declare v1 int default 1;
    declare v2 int default 2;
    declare block char(5) default "outer";
    declare c1 condition;
    declare c2 condition;
    declare continue handler for c1 
        begin
            set v1 = 10;
            set v2 = 20;
        end;
    select block, v1, v2;
    begin 
        declare block char(5) default "inner";
        declare continue handler for c1 set v1 = 100;
        declare continue handler for c2 set v2 = 200;
        select block, v1, v2;
        signal c1;
        select block, c1, v1, v2;
        signal c2;
        select block, c2, v1, v2;
    end;
    signal c1;
    select block, c1, v1, v2;
end;