GetLockMode Function

This function returns the locking mode, which determines whether or not access is enabled to versioned rows and corresponding rows in the previous version.

Syntax

DBMS_WM.GetLockMode
RETURN VARCHAR2;

Usage Notes

This function returns E, S, C, or NULL:

• For explanations of 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.

Examples

The following example displays the locking mode in effect for the session.

SELECT DBMS_WM.GetLockMode FROM DUAL;

GETLOCKMODE                                                                     
--------------------------------------------------------------------------------
C