Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Rob Yslas — — source: Informix-list mailing list archive (1991-1998)
Is there a reason that I would be getting an error code of -267 (The cursor has
been previouly released and is unavailable) after several rows have been fetched
and the cursor has not been closed.
for example (assume the cursor has been declared with an into clause)
$open test_curs;
$fetch test_curs;
while (sqlca.sqlcode == 0){
/* some logical work gets done with the data */
fetch test_curs;
} /* end while */
$close test_curs;
It works ok for several passes but fails with a -267 error code and exits the
while loop.
Any help would be appreciated.
Thanks in advance,
Rob Yslas
--
yslas@uswat.uswest.com
Thanks
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.