Set Lock TimeOut in ORACLE 7.3

From: Nikki Khurana <knikkix_at_yahoo.com>
Date: 2 Oct 2002 13:17:55 -0700
Message-ID: <4e5eab48.0210021217.4dc96e19@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 - 15:17:55 CDT