Re: Changing isolation level?

While stranded on information super highway mcstock wrote:
:)
:)"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
:)news:1070486233.549645_at_yasure...
:)| D Alpern wrote:
:)|
:)| > SELECT... FOR UPDATE {WAIT | NOWAIT} springs to mind...
:)| >
:)| > David
:)|
:)| Why would that spring to mind?
:)|
:)| It doesn't block a read which is the point of the OP's request.
:)|
:)| --
:)| Daniel Morgan
:)| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
:)| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
:)| damorgan_at_x.washington.edu
:)| (replace 'x' with a 'u' to reply)
:)|
:)
:)actually, it does... it voluntarily blocks the read that it itself
:)(grammar?) is attempting to do
:)
:)so, on a case by case basis (instead of a session or instance isolation
:)level setting), the reader gets blocked by the writer
:)
:)unfortunately, the reader that uses this syntax now blocks writers, but if
:)serialization is what's required to meet the business requirement, this
:)would seem to do it
:)--
:)Mark C. Stock
:)mcstock -> enquery(dot)com
:)www.enquery.com training & consulting
:)

This will not work.

I have to read the next row to find out what it is and then delete it. If another process has already deleted the row, I should be getting the old value. Oracle will not block readers.

:)
:)

-- 
Hemant Shah                           /"\  ASCII ribbon campaign
E-mail: NoJunkMailshah_at_xnet.com       \ /  --------------------- 
                                       X     against HTML mail
TO REPLY, REMOVE NoJunkMail           / \      and postings      
FROM MY E-MAIL ADDRESS.           
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind,                Above opinions are mine only.
it's backed up on tape somewhere.      Others can have their own.