Re: Changing isolation level?

Hemant Shah wrote:

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

If I see one more happy face I'm going to break something. Who started this ;-) ;-) ;-) nonsense anyway?

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