Re: Isolation level on Ora 9i
Date: 17 Sep 2003 00:30:11 -0700
Message-ID: <a1d154f4.0309162330.4f2f8815_at_posting.google.com>
"Robert Vabo" <rvabo_at_msn.com> wrote in message news:<3f66f1bf$1_at_news.wineasy.se>...
> I have an VB6 application using transactions. The database is Oracle 9i and
> I use the native Oracle OLEDB provider to access data.
> When I use the this code:
>
> cn.IsolationLevel = adXactReadUncommitted
> cn.BeginTrans
>
> I get an error message with number -2147168248 telling me that the isolation
> level is not supported. I use this on COM+.
>
> If I use the Microsoft OLEDB driver for Oracle it works, but I am handling
> BLOBs containing documents so I have to use the native driver.
>
> What kind of isolation level is supported on Oracle 9i ?
Goto http://tahiti.oracle.com and search on isolation level. My fee for doing your work and answering mere doc questions is $200 per hour.
Sybrand Bakker
Senior Oracle DBA
Received on Wed Sep 17 2003 - 09:30:11 CEST