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