Re: isolation levels - I think?

Hi Adam,

No, you don't want to change isolation level or anything like that. As I understand your situation, you see the changed data in same session, right? If you see the data in the other session, there are only 2 possibilities:
1. ( most likely ) You are committing somewhere. 2. the isolation level was changed.

HTH,
Michael

• Original Message ----- From: "Adam Turner" <ATurner_at_concreteinc.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 18, 2000 09:35 Subject: isolation levels - I think?

> I have a developer trying to do a multi table update on the database that
> contains one begin and one commit at the end. In theory we are trying to
> update all of these tables - without changing the data accessed by the
rest
> of the application until the commit. This means that there should be no
> change ... then a commit .. then new data should be seen. Instead we are
> seeing partially updated tables and data throughout the update process.
>
> I am new to Oracle, and I must admit I don't exactly know what is going on
> here. Do I need to change the isolation level of the updates - or of the
> reads to achieve the desired result?
>
> thanks
>
> adam
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Adam Turner
> INET: ATurner_at_concreteinc.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Oct 18 2000 - 09:40:04 CDT