Re: SQL Plus & Locks

Carlos Hernández wrote:
>
> Hi,
>
> I need resolve a little question ...
>
> If I locks a row with any tool, and open a session with the SQL PLus and try
> to make a Update of the same row, not returns a ORA-????? with the error.
> How I can detect the error? SQL Plus is not available this possibility?
>
> Thanks and best regards.
>
> Carlos Hernández
> Barcelona (Spain)

select *
from my_table
for update NOWAIT;

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."