Re: OCIReset() always fails

From: Knut Stolze <stolze_at_informatik.uni-jena.de>
Date: Fri, 06 Jun 2003 19:32:33 +0200
Message-ID: <bbqj7h$fbr$1@fsuj29.rz.uni-jena.de>

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

Received on Fri Jun 06 2003 - 12:32:33 CDT