You have to be a little careful doing this.
You need to delete by ROWID, not by
the original conditions in case someone
else (say) adds a new row, commits, then
locks the row between your select and delete.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Karen wrote in message <39F067EA.7166B650_at_fmr.com>...
>DELETE always hangs if the row is "taken". There is no NOWAIT option.
>
>But you can use SELECT FOR UPDATE with NOWAIT to lock the rows you are
going
>to delete and then doing DELETE on them.
>
>
>Bill Weinberger wrote:
>
>> I know how to use NOWAIT to keep SELECT...FOR UPDATE from blocking on
>> Resource busy. But, how can I accomplish the same thing when I am
deleting
>> rows, too?
>>
>> Thanks for your help.
>> Bill
>
Received on Mon Oct 23 2000 - 15:10:36 CDT
