Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OCI7 Closing Explicit Cursors?

OCI7 Closing Explicit Cursors?

From: Deacon Taminant <erisKILLTHIS_at_pcisys.net>
Date: 15 May 1999 18:42:25 GMT
Message-ID: <7hkf6h$jj9$1@remarQ.com>


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.

Received on Sat May 15 1999 - 13:42:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US