More V8.x ODBC trouble (ORA-08177)

From: Gerard van Dorth <gerard.van.dorth_at_vdc-it.nl>
Date: Thu, 4 Nov 1999 18:02:53 +0100
Message-ID: <941734403.22410.0.pluto.d4ee362b@news.demon.nl>

Hi,

Trying to commit 100 simple insert on highest isolation level, we get the error ORA-08177 using ODBC V8.1.54.

Simplified we do the following in a loop 100 times (on a serializable level)

    INSERT INTO "simpleTable" ...                        (Statement reused,
only bind values differ)
    SELECT COUNT(*) from "simpleTable" ...     (=SQLExecDirect)

At iteration 55 the SELECT pops-up with an ORA-08177 (reproducible - having a single connect to the database).

The loop works fine if:

    We do 54 iterations
    Skip the SELECT COUNT(*)
    Use Oracle 7.3.x ...

Any help, suggestions will be appreciated, Thanks in advance,
Gerard van Dorth Received on Thu Nov 04 1999 - 11:02:53 CST