Re: Q: elementary transaction question

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 14 Dec 2004 21:39:52 +0100
Message-ID: <0qjur0d1nvksfm02vbdqf3sgemf8g2ehc6@4ax.com>

On 14 Dec 2004 10:46:51 -0800, yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:

>
>What IS the correct way to prevent this?

alter session set isolation_level = serializable (default : read_comitted)

Will savepoint do this, do I even
>need to do anything? The oracle manual has lots of examples of multiple
>updates , or read-only consistancy, but I don't see this.
>
>
>
>(not correct plsql, just outline)

Even as outline horrible code. Never do anything procedurally, if it can be accomplished by SQL.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 14 2004 - 14:39:52 CST