CWM2_OLAP_HIERARCHY , 6 of 12

LOCK_HIERARCHY Procedure

This procedure locks the hierarchy metadata for update by acquiring a database lock on the row that identifies the hierarchy in the CWM2 model table.

Syntax

LOCK_HIERARCHY (
           dimension_owner     IN   VARCHAR2,
           dimension_name      IN   VARCHAR2,
           hierarchy_name      IN   VARCHAR2,
           wait_for_lock       IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 20-6 LOCK_HIERARCHY Procedure Parameters

Parameter	Description
`dimension_owner`	Owner of the dimension.
`dimension_name`	Name of the dimension.
`hierarchy_name`	Name of the hierarchy.
`wait_for_lock`	(Optional) Whether or not to wait for the hierarchy to be available when it is already locked by another user. If you do not specify a value for this parameter, the procedure does not wait to acquire the lock.

Exceptions

Table 20-7 LOCK_HIERARCHY Procedure Exceptions

Exception	Description
`no_access_privileges`	User does not have the necessary privileges. User must be the dimension owner and have the `OLAP_DBA` role.
`dimension_not_found`	Parent dimension not found.
`hierarchy_not_found`	Hierarchy not found.