[Info-ingres] raise error crocked?

[Martin Bowes]

Hi All,

II 11.0.0 (a64.lnx/100) + p15426

What am I doing wrong?

create procedure inner
as
begin
    raise error 99999 'inner(): I''m bad';
end;

create procedure outer
as declare
    msg  varchar(256) not null;
    enum integer4 not null not default;
begin
    execute procedure inner;
    select iierrornumber into :enum;
    if (:enum != 0) then
        msg = 'call to inner has error: ' + varchar(:enum);
    else
        msg = 'call to inner OK';
    endif;
    message :msg;
end;

And so when I execute procedure outer;

I get:

MESSAGE 0: call to inner OK
inner(): I'm bad

It's like the error code I asked for has just not been set.

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190605/9823b052/attachment.html>