More info ...
Though Oracle ODBC reports SQL_CURSOR_COMMIT/ROLLBACK_BEHAVIOR to be
SQL_CB_PRESERVE the application runs quite better assuming a SQL_CB_DELETE
here ... better but slower.
Is this a known problem?
Gerard van Dorth wrote in message
<941734403.22410.0.pluto.d4ee362b_at_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 Fri Nov 05 1999 - 07:31:52 CST
