Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL AND LOCK

Re: PL/SQL AND LOCK

From: grinalds <grinalds_at_konts.lv>
Date: 1997/09/15
Message-ID: <341D247A.253F480E@konts.lv>#1/1

Matteo Lonardi 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.
>
> Does anybody know how can I be able to do it?
>
> Thanks in advance.
>
> Matteo Lonardi
> teo_at_romeo.sci.univr.it

Try to use "FOR UPDATE t.column_name" where t - table alias.

Grinalds Received on Mon Sep 15 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US