Subject Re: Triggers suitability
Author Ali Gökçen
there may be occur some other users commits between select and delete
commands related about same records..

You may choice snapshot isolation level to escape from new commits
or you can use "where current of" clause to be sure about it is the
selected cursor record..
Or you can use another atomic id number to be sure about selected
record is deleted. etc..