Re: Can I lock a Row in a Oracle Table ?

Hi,

A point to add is that I discovered that if the lock mode is 3 on a particular
row, then even select with "nowait" option will "hang" until the lock is release.

I am having this problem at the moment where records are locked for a long time.
The v$locked_object item just cannot be removed.

Thorough checks through the stored procedures have revealed no clue to this type of
lock.

If anyone has any ideas. Pls reply. Thanks

PS: Sorry that I did not start a new thread for this topic.

Nicolas Bronke wrote in message <3729617c_at_news.uk.ibm.net>...
>
>Thomas Kyte <tkyte_at_us.oracle.com> schrieb in im Newsbeitrag:
>372aff43.2399249_at_192.86.155.100...
>> >Can I lock a Row in a Oracle Table ? Or how can I handle one record
>> >being change by two users ?
>>
>> select * from T where pk = value FOR UPDATE;
>>
>> will lock the row(s) selected.
>>
>and with the option nowait it will be returned a error-code immediatly
>whether the record is already locked. Otherwise this command wait until the
>record is unlocked.
>Regards
>Nicolas Bronke
>
>
Received on Fri Apr 30 1999 - 10:46:01 CDT