INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

In an environment with a local server calling a stored procedure
which is calling a stored procedure on a
remote server and the local server attempts to convert a
returned value to a lvarchar, the local stored
procedure does not come back.

The Stored Procedures look like this :

remote :

create procedure _t1() returning int,boolean,smallint,boolean;
return 2::int,'t'::boolean,1::smallint,'f'::boolean;
end procedure;

local
create procedure _t2();
define l_a lvarchar;
define l_d,l_b boolean;
define l_c smallint;

foreach
                execute procedure database1@server1:_t1()
                                into l_a,l_b,l_c,l_d

                                let l_a=l_a;
                                let l_b=l_b;
                                let l_c=l_c;
                                let l_d=l_d;
end foreach;
end procedure;

The stored procedure in the usual case would process one result
set and return.  In 12.10.FC8 and newer it
loops and does not come back.

****************************************************************
* USERS AFFECTED:                                              *
* Informix users with remote UDT casting in SPL procedure      *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.03.2017
10.07.2017
10.07.2017

12.10.xC9