Re: PL/SQL AND LOCK

From: David S. Johnson <dsjohnso_at_ingr.com>
Date: 1997/09/16
Message-ID: <01bcc2e9$c6443aa0$53be8781@DAVIDJ>#1/1

Perhaps your select for update is failing because someone else has the table locked. Try using the NOWAIT option, testing the return code, and returning a msg if the record is currently locked by another user.

Thomas Kyte <tkyte_at_us.oracle.com> wrote in article <34191360.9790728_at_newshost>...
> On Wed, 10 Sep 1997 15:03:32 +0200, Matteo Lonardi
<teo_at_romeo.sci.univr.it>
> wrote:
>
> >I have to lock only one record (or a set of record) in PL/SQL.
> >I have tried to use a cursor FOR UPDATE but it doesn't seem to work.
> >
Received on Tue Sep 16 1997 - 00:00:00 CDT