Found this on Ask Tom ...


select t.*, rowid from T
where t.c1 = :block.c1
and t.c2 = :block.c2
and ....
and t.rowid = :block.rowid
FOR UPDATE NOWAIT;

if that returns ORA-54 (resource busy), you are notified someone else has that row locked.

So I imagine If I cater for ORA-54 in my EXCEPTION handling section I can at least warn the user.

Any PL\SQL experts care to comment?