Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
UTL_REF , 3 of 5
This procedure locks an object given a reference. In addition, this procedure lets the program select the locked object. The semantic of this subprogram is similar to the following SQL statement:
SELECT VALUE(t) INTO object FROM object_table t WHERE REF(t) = reference FOR UPDATE;
Unlike the above SQL statement, this subprogram does not require you to specify the object table name where the object resides. It is not necessary to lock an object before updating/deleting it.
UTL_REF.LOCK_OBJECT ( reference IN REF "<typename>"); UTL_REF.LOCK_OBJECT ( reference IN REF "<typename>", object IN OUT "<typename>");
Parameter | Description |
---|---|
reference |
Reference of the object to lock. |
object |
The PL/SQL variable that stores the locked object. This variable should be of the same object type as the locked object. |
May be raised.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|