Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.nuthinbutnews.com!propagator2-sterling!in.nntp.be!news2.euro.net!newsfeed.freenet.de!news-lei1.dfn.de!news.uni-jena.de!not-for-mail
From: Knut Stolze <stolze@informatik.uni-jena.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: OCIReset() always fails
Date: Fri, 06 Jun 2003 19:32:33 +0200
Organization: IBM
Lines: 27
Message-ID: <bbqj7h$fbr$1@fsuj29.rz.uni-jena.de>
References: <bbq6he$d73$1@fsuj29.rz.uni-jena.de> <sm2Ea.129$vS4.16578755@newssvr13.news.prodigy.com>
NNTP-Posting-Host: ipc611.inf.uni-jena.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
X-Trace: fsuj29.rz.uni-jena.de 1054920753 15739 141.35.14.33 (6 Jun 2003 17:32:33 GMT)
X-Complaints-To: news@rz.uni-jena.de
NNTP-Posting-Date: 6 Jun 2003 17:32:33 GMT
User-Agent: KNode/0.7.2
Xref: core-easynews comp.databases.oracle.server:188899
X-Received-Date: Fri, 06 Jun 2003 10:31:51 MST (news.easynews.com)

Dave Hau wrote on Friday 06 June 2003 17:24:

> Try patching your OCI library to 8.1.7.4.
> 
> In the list of bugs fixed for 8.1.7.4, I see this bug:
> 
>       8174 2265777 OCIBreak() -> OCIReset() does not close the cursor (can
> lead to ORA-1000)

Thanks, I'll see if the patch can be applied and then try again.

> 1. OCIHandleAlloc(stmthp)
> 2. OCIStmtPrepare(stmthp)
> 3. OCIStmtExecute(stmthp)
> 4. OCIBreak(svchp)
> 5. OCIReset(svchp)
> 4. OCIHandleFree(stmthp)
> 5. OCITransCommit()
> 6. go back to 1.
> 
> The cursor opened at 3 won't close until session is terminated.

Is there, by any chance, an explicit way to close the cursor before or after
the OCIBreak()?  I hope I could use that as an interim work-around.

-- 
Knut Stolze