RE: Errors 258 and 259

You don't perhaps have if / case statements, and somewhere forgot to open or close a cursor ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Steve Giles Sent: Wednesday, June 09, 2004 1:43 PM To: informix-list@iiug.org Subject: Errors 258 and 259 Hello all, We have a client who is getting sporatic -258 and -259 messages while trying to insert a record. A little background on the application; It is an OLTP environment that passes through financial transactions. It is a 9.21.UC3 with AIX5.1 environment. I understand that the errors have to do with cursors and the fact that it cannot be found. What I'm not sure is why this is happening. Our application declares and opens a cursor before every transaction (I know it is not necessary to declare the cursor every transaction, but I think that is another matter), and then closes it when it is done. I've been talking to Informix and they say it must be a flaw in our code (we use ESQL), but if it was a flaw I'm thinking that this would be occuring more often (it has only happened twice in the past two days). Also we have other client sites running the same code and this has never happened. Does anyone have any thoughts as to what could be happening? Thanks in advance Steve. ________________________________ << ella for Spam Control >> has removed 1660 Spam messages and set aside 684 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list