LOCK_MEASURE Procedure

This procedure locks the measure's metadata for update by acquiring a database lock on the row that identifies the measure in the OLAP 2 Catalog.

Syntax

LOCK_MEASURE (
           cube_owner        IN   VARCHAR2,
           cube_name         IN   VARCHAR2.
           measure_name       IN   VARCHAR2,
           wait_for_lock     IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 23-6 LOCK_MEASURE Procedure Parameters

Parameter	Description
cube_owner	Owner of the cube.
cube_name	Name of the cube.
measure_name	Name of the measure to be locked.
wait_for_lock	(Optional) Whether or not to wait for the measure 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 23-7 LOCK_MEASURE Procedure Exceptions

Exception	Description
no_access_privileges	User does not have the necessary privileges. User must be the owner and have the OLAP_DBA role.
cube_not_found	Cannot lock measure. Its cube does not exist within the OLAP 2 Catalog.
measure_not_found	Cannot lock measure. This measure does not exist for this cube.