Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 17 of 52
This function returns the locking mode, which determines whether or not access is enabled to versioned rows and corresponding rows in the previous version.
DBMS_WM.GetLockMode RETURN VARCHAR2;
This function returns E
, S
, C
, or NULL
:
E
(exclusive), S
(shared), and C
(carry-forward), see the description of the lockmode
parameter of the SetLockingON Procedure.
NULL
indicates that locking is not in effect. (Calling the SetLockingOFF Procedure results in this setting.)
For an explanation of Workspace Manager locking, see Oracle9i Application Developer's Guide - Workspace Manager. See also the descriptions of the SetLockingON Procedure and SetLockingOFF Procedure.
The following example displays the locking mode in effect for the session.
SELECT DBMS_WM.GetLockMode FROM DUAL; GETLOCKMODE -------------------------------------------------------------------------------- C
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|