Re: No more temporary string storage

>From: Kostas Flokos <100303.1316@CompuServe.COM> >Subject: No more temporary string storage >Date: 18 Sep 1994 14:10:04 GMT >X-Informix-List-Id: <news.8757> This message arrived with one 400-character line. Please remember the new-line key when posting... >I am using Informix On-Line ver.4.00 UC1 with SCO UNIX ver. 3.2. In one >of my programs, I am calling a couple of functions with cursors from a >small loop (1-10 times interation). From time to time I get an error >message of "can not allocate any more spac for temporary string storage". >This error never appeared in the previous version of Informix (ver. 4.0 >SE). >Any help is greatly appreciated. First off, though you don't mention it, you are also using I4GL, and the error message number is -4518, and it comes from I4GL and not from SE. Secondly, it is a very nasty problem, caused by bug B01857 in I4GL. There is a workaround -- but it involves a lot of careful recoding of dubious constructs in I4GL programs. Trying to fix the problem is also very stressful on hair; it tends to go grey overnight, what little hasn't been pulled out:-( By far the best way of fixing this is to get hold of the 4.12 release of I4GL -- the bug was fixed completely and the 4.12 product never generates the dreaded -4518 message. It also removes the need for error -4517 too, but that was a largely coincidental side-effect. B01857 was also fixed in version 6.00 of I4GL. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>