Re: Too many cursors?

There's always a limit, but I doubt your hitting one. Did you check the sqlcode after the declare? -Bill } } 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 -----------------+ } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com