Informix - Problem description
Problem IT19490 | Status: Closed |
SPL CALLING A REMOTE STORED PROCEDURE REQUIRING CONVERSIONS OF DATATYPES TO A LVARCHAR CAUSES ENDLESS LOOP | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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. | |
Problem Summary: | |
**************************************************************** * 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 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.03.2017 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |