SetLockingOFF Procedure

This procedure enables access to versioned rows and to corresponding rows in the parent workspace.

Syntax

DBMS_WM.SetLockingOFF();

Usage Notes

This procedure turns off Workspace Manager locking that had been set on by the SetLockingON Procedure. Existing locks applied by this session remain locked. All new changes by this session are not locked.

Examples

The following example sets locking off for the session.

EXECUTE DBMS_WM.SetLockingOFF;