Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.7 ODBC can't see changes made by other process

Re: Oracle 8.1.7 ODBC can't see changes made by other process

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 19 Sep 2001 13:40:49 GMT
Message-ID: <Bf1q7.4808$JN.18807@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
"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US