RE: isolation levels

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Wed, 18 Oct 2000 10:29:04 -0400
Message-Id: <10653.119648@fatcity.com>

There are two possibilities:
a) You encountered a really disaterous, previosly unknown oracle bug which

can warrant a recall.
b) There is a commit statement somewhere in your code, either explicit or

implied. Check your code for using DDLs like truncate, drop or create, either in the script or by using EXECUTE IMMEDIATE or DBMS_SQL.

-----Original Message-----
From: Adam Turner [mailto:ATurner_at_concreteinc.com] Sent: Wednesday, October 18, 2000 9:36 AM To: Multiple recipients of list ORACLE-L 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:29:04 CDT

RE: isolation levels - I think?