SQL Error: No SQL Cursors remaining
SQL Error: No SQL Cursors remaining
(OP)
I am running centura 2.1 using an oracle database
Client 8.17
The users are getting this error a couple of time a day.
I had the DBA check the oracle cursors open and they were way below the limit.
Any help would be appreciated.
Client 8.17
The users are getting this error a couple of time a day.
I had the DBA check the oracle cursors open and they were way below the limit.
Any help would be appreciated.
RE: SQL Error: No SQL Cursors remaining
I can send you a class to manage Sql Handles if you like and try it out - but it may require lots of work to plug into your app., but have never had any probs with Sql cursors, so it must be working Ok. Only ever used it on Oracle7.3, Sqlbase, Informix and SqlServer though. It maybe an Oracle8 thing.
RE: SQL Error: No SQL Cursors remaining
I opened a ticket with GUPTA.
They told me that I should follow every SqlImmediate
with a sqlClearImmediate.
Do you agree with this.
Thanks,
Bill
RE: SQL Error: No SQL Cursors remaining
I guess I would never use SqlImmediate() in the first place. If you are using it, you have no control over the cursor, so you do need to use SqlClearImmediate() which may help the problem.. but I think better style is to use a Sql Handle class as described above, or SqlConnect() and SqlPrepareAndExecute() etc. lemme know if want a class to manage your handles...