Too many cursors?

Posted in 1997

Nigel Gall — 4 Feb 1997 11:38:14 -0500 — source: Informix-list mailing list archive (1991-1998)

Is it possible to open too many cursors? I have a function that declares a normal cursor, opens it, and then fetches the first row. The program bombs at the fetch with error number -400: SQL statement error number -400. Fetch attempted on unopen cursor. the sample code is as follows: ... declare curs cursor for <select statement> open curs fetch curs into vars.* ... There is no syntax error in the select statement, nor any of the statements. Sometimes I get core dumped! I'm using RDS 6.03.UC1, SE 7.12.UC1 on SCO OpenServer Desktop Rel. 5.0.0 on an AST Bravo MS-T P/166 with 16MB RAM and no other programs in progress. Any ideas? Best regards, Nigel -- +--------------------------------------------------------------------+ | Name : Edmund Nigel Gall Address: 9A Stanmore Avenue | | Title : Account Executive Port of Spain | | Company : Stratis Caribbean Ltd. Trinidad & Tobago, W.I. | | | | Contact Information: | | Office Personal | | Voice : (809) 623 6530/1 (809) 662 6611 | | Fax : (809) 623 8370 (809) 662 6611 | | Email : ngall@stratis-caribbean.com nigelg@trinidad.net | +----------------- http://www.stratis-caribbean.com -----------------+