LOCK_CATALOG Procedure

This procedure locks the measure folder metadata for update. A database lock is acquired on the row for the measure folder in the CWM model table.

Syntax

LOCK_CATALOG (
   catalog_id            IN   NUMBER,
   wait_for_lock         IN   BOOLEAN);

Parameters

Table 28-19  LOCK_CATALOG Procedure Parameters

Parameter	Description
catalog_id	Identifier of the measure folder.
wait_for_lock	When true, wait for lock to released if it has already been acquired by another user. The default is false.

Exceptions

Table 28-20  LOCK_CATALOG Procedure Exceptions

Exception	Description
catalog_not_found	Measure folder not found.
failed_to_gain_lock	Failed to acquire lock.
no_access_privileges	User does not have privileges to edit the measure folder. User must be the owner or OLAP_DBA.