Re: Oracle 8 and locked rows

From: Pascal Paradis-Théberge <pascal_at_ia-us.com>
Date: 1998/01/30
Message-ID: <34D24DAF.9B147D53@ia-us.com>#1/1

> try
>

> SELECT 1
> FROM your table
> WHERE <condition for the row you want to check>
> FOR UPDATE NOWAIT;
>

> If you get an 'ORA-00054 resource busy' the row was already locked in
> another session. If not then your're holding the lock now until you
> commit or rollback.

My problem is that I am trying to get the result within a query. Something that would give

Item number is locked

1234123           Y
4563456           N
8565456           Y

Can you help me with this one?

Pascal Paradis-Th berge
pascal_at_ia-us.com Received on Fri Jan 30 1998 - 00:00:00 CST