RE: isolation levels - I think?

Thanks Michael,

They are different sessions and different connections. I don't think the isolation level was changed, but if so where would that change be occuring ... probably on the reading data level ... and if so it would need to be explicitly stated before the transaction. I know this is not being done so I agree that this is probably not the case.

There is not commit in the Procedure. It has been checked and triplechecked. Perhaps I am missing it, but it looks OK. A commit is only for the current session right? And any given user can have n sessions ... so if a commit is issued in another session there really is no way for it to commit these updates ...

Solution that is working currently. A second login / connection for the updates that is used for this task. This way I gain finer security control over the updates anyway .. and I achieve the desired result of the commit.

thanks for the input though.

Hope all is well

Adam

-----Original Message-----
From: Michael Netrusov [mailto:mn_at_g-fax.com] Sent: Wednesday, October 18, 2000 11:41 AM To: Multiple recipients of list ORACLE-L Subject: 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 ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 18, 2000 09:35

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  INET: mn_at_g-fax.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