Part 2: The 32-Bit/64-Bit Drivers : The Oracle Driver : Connection Option Descriptions : Lock Timeout

Lock Timeout
Attribute
LockTimeout (LTO)
Purpose
Specifies the amount of time, in seconds, the Oracle server waits for a lock to be released before generating an error when processing a Select...For Update statement on an Oracle 9i or higher server.
Valid Values
-1 | 0 | x
where:
x
is an integer that specifies a number of seconds.
Behavior
If set to -1, the server waits indefinitely for the lock to be released.
If set to 0, the server generates an error immediately and does not wait for the lock to time out.
If set to x, the server waits for the specified number of seconds for the lock to be released.
Notes
If you are connected to an Oracle 8i server, any value greater than 0 is equivalent to the value -1.
Default
-1
GUI Tab
Figure 3
See Also
See Performance Considerations for details.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.