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
In article <Bf1q7.4808$JN.18807_at_news1.sttls1.wa.home.com>, Jim Kennedy says...
The other point is:
If you start the select gathering all the data from the whole table (supposing this is taking some time), oracle supplies you with a read consistent view from the point when you started the query, so that the changes made to several records won't be part of the consistent view.
Matthias
>
>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:49:26 CDT