Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCI7 Closing Explicit Cursors?
I've been working with the Oracle 7 OCI and finally have a
working generic middleware with all the major bugs worked
out except for one...
When I bind a cursor to be 'opened for' in a stored procedure, (using obndra, I believe) the cursor remains 'open' in Oracle. After switching stored procs and obndra'ing the same CDA_Def about 50 times, I get a 'too many cursors open' error.
Does anyone know how I can close the fetch cursor and effectively release it? I've tried ocan (), oclose (), but none of them seem to change this.