Re: Row level locking: how to do it?

Hi Lim,

look for : 'for update of '

eg.

select ename
from emp
where enumber = 102
for update of ename;

ir Danny Roosens
Genesys Belgium

mte_at_moe.ac.sg (Lim Tik Meng) wrote:
>We are trying to solve a problem involving concurrency processing in
>embedded SQL in forms 4.5 trigger. We will greatly appreciate if anyone
>could guide us on how to do row level blocking. The Lock Table command
>doesnot work for row level locking.
>
>regards,
>
>Peter
>
Received on Mon Aug 05 1996 - 00:00:00 CEST