Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 ODBC can't see changes made by other process
Wrong! The writing process finished its transaction correctly. Any
Process who is started after the inserting transaction can see the
data, but not this one which was started just before the inserting
transaction.
Besides: With the Oracle 8.0.5 ODBC driver it works well - it seems to
be a problem of the new oracle 8.1.7 ODBC driver or the MDAC.
Michael
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<Bf1q7.4808$JN.18807_at_news1.sttls1.wa.home.com>...
> Let me guess, the process writing the data has not done a commit.
> If the process writing the data has not done a commit (completed the
> transaction) then the process reading the data won't see it.
> This is normal.
> Jim
Received on Wed Sep 19 2001 - 17:21:46 CDT