Informix - Problem description
Problem IT37988 | Status: Closed |
EXECUTE VARIOUS DYNAMIC SQL WITH DIFFERENT RETURN PARMS IN A LOOP IN A SP THEY RUN OUT OF SYNC AND RETURN 720 | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Given the following logic SP1 calls SP2 SP2 defines a loop of select dynamic SQL text from a table prepare/declare a cursor on the selected SQL text execute the cursor into local variables based on the select list close/free cursor the execute of the cursor SP2 returns occasionally error -720 instead of returning the expected result set. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.08.2021 02.11.2021 02.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |