The locks don't time out unless it is a deadlock. Try select for update
nowait.
Jim
"Nikki Khurana" <knikkix_at_yahoo.com> wrote in message
news:4e5eab48.0210021217.4dc96e19_at_posting.google.com...
> Hi All,
>
> I am in big trouble. I am trying to find out the answer from 2 days
> but no luck.
>
> I am describing my problem, please help me
>
> We are using ORACLE 7.3 with VB 6.0 as frontend.
>
> In the application, we are applying the LOCKS when User change from
> View Mode to Edit Mode using the statement SELECT .... For UPDATE.
>
> With the statement, the lock is applied but after I think 1 minute the
> lock get automatically released as I can modify the same record in SQL
> Worksheet.
>
> I think I have to set DISTRIBUTED_LOCK_TIMEOUT property but i don't
> know the command to set it.
>
> If I am wrong at any point, please let me know.
>
> Thanks for any help
> Nikki
Received on Wed Oct 02 2002 - 22:11:14 CDT
