SetWorkspaceLockModeOFF Procedure

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

Syntax

DBMS_WM.SetWorkspaceLockModeOFF(
   workspace  IN VARCHAR2);

Parameters

Table 70-40 SetWorkspaceLockModeOFF Procedure Parameters  

Parameter	Description
workspace	Name of the workspace for which to set the locking mode off. The name is case sensitive.

Usage Notes

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

An exception is raised if any of the following occurs:

• The user does not have the WM_ADMIN_ROLE role or is not the owner of workspace.

• There are any open regular transactions in workspace.

• workspace is a continually refreshed workspace (see the description of the isrefreshed parameter of the CreateWorkspace Procedure).

Examples

The following example sets locking off for the workspace named NEWWORKSPACE.

EXECUTE DBMS_WM.SetWorkspaceLockModeOFF('NEWWORKSPACE');