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 -----------------+