Re: Question about locking a record.

cschang wrote:
>
> Thanks Steve. I know I can use " FOR UPDATE" at end of the "SELECT ..".
> but how can I lock it for a certain of period , not at the moment of the
> "SELECT .." and consequently "UPDATE.. " statement. Because my next
> step of the possible process will make the record not available for any
> other user, so I do not want the reocrd to be updated after my updating
> unless I do not process further. I hope that above statement does
> confuse you.
>
> C Chang
>
> Steve Bell wrote:
>
> >Hi,
> >
> >I hope I understand your question...if you want to select a record and lock
> >it you can use the SELECT...FOR UPDATE
> >syntax.
> >
> >Hth,
> >
> >Steve
> >
> >

check out dbms_lock

hth connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."