Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOCK , 5 of 6
This function explicitly releases a lock previously acquired using the REQUEST
function. Locks are automatically released at the end of a session. RELEASE
is an overloaded function that accepts either a user-defined lock identifier, or the lock handle returned by the ALLOCATE_UNIQUE
procedure.
DBMS_LOCK.RELEASE ( id IN INTEGER) RETURN INTEGER; DBMS_LOCK.RELEASE ( lockhandle IN VARCHAR2) RETURN INTEGER;
Parameter | Description |
---|---|
id or lockhandle |
User assigned lock identifier, from 0 to 1073741823, or the lock handle, returned by |
Return Value | Description |
---|---|
0 |
Success |
3 |
Parameter error |
4 |
Do not own lock specified by |
5 |
Illegal lock handle |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|