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
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
"Michael Wernado" <michael.wernado_at_logisoft-s.de> wrote in message
news:39dfee35.0109190526.15ad6d94_at_posting.google.com...
> We have an Oracle 8.1.7 Database (also tested with 8.1.5) and the
> Oracle ODBC Driver.
>
> There are two Processes, one writing data, the other reading them. It
> is impossible to the reading process to get the data until he is
> restarted.
> Also a second instance of the reading process is able to read the
> data, but not the one who was started before the writing process has
> inserted rows.
>
> What the hell is wrong?
>
> Thanks
>
> Michael Wernado
> michael.wernado_at_logisoft-s.de
Received on Wed Sep 19 2001 - 08:40:49 CDT