Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOCK , 4 of 6
This function converts a lock from one mode to another. CONVERT
is an overloaded function that accepts either a user-defined lock identifier, or the lock handle returned by the ALLOCATE_UNIQUE
procedure.
DBMS_LOCK.CONVERT( id IN INTEGER || lockhandle IN VARCHAR2, lockmode IN INTEGER, timeout IN NUMBER DEFAULT MAXWAIT) RETURN INTEGER;
Parameter | Description |
---|---|
id or lockhandle |
User assigned lock identifier, from 0 to 1073741823, or the lock handle, returned by |
lockmode |
New mode that you want to assign to the given lock. The available modes and their associated integer identifiers are listed below. The abbreviations for these locks, as they appear in the V$ views and Enterprise Manager monitors are in parentheses. 5 - share row exclusive mode (ULRSX) Each of these lock modes is explained in Oracle8 Concepts. |
timeout |
Number of seconds to continue trying to change the lock mode. If the lock cannot be converted within this time period, then the call returns a value of 1 (timeout). |
Return Value | Description |
---|---|
0 |
Success |
1 |
Timeout |
2 |
Deadlock |
3 |
Parameter error |
4 |
Don't own lock specified by |
5 |
Illegal lock handle |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|