Re: Changing isolation level?

From: <ctcgag_at_hotmail.com>
Date: 04 Dec 2003 15:59:10 GMT
Message-ID: <20031204105910.407$Rp@newsreader.com>

NoJunkMailshah_at_xnet.com wrote:

(Pertaining to using select for update to voluntarily be blocked by
>writers)
>
> This will not work.
>
> I have to read the next row to find out what it is and then delete it.

What do you mean "next row". You want to skip the one that's locked? Does DB2 or whatever do this? I would think they just block on the one that's locked, not skip it.

> If another process has already deleted the row, I should be getting the
> old value.

Are you using "should" to describe what you desire, or what you think is going on?

> Oracle will not block readers.

Unless the readers ask for it.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB

Received on Thu Dec 04 2003 - 09:59:10 CST