Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

LOCK_LEVEL_ATTRIBUTE Procedure

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

Syntax

LOCK_LEVEL_ATTRIBUTE (
           dimension_owner            IN   VARCHAR2,
           dimension_name             IN   VARCHAR2,
           dimension_attribute_name   IN   VARCHAR2,
           level_name                 IN   VARCHAR2,
           level_attribute_name       IN   VARCHAR2,
           wait_for_lock              IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 22-7  LOCK_LEVEL_ATTRIBUTE Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

dimension_attribute_name

Name of the dimension attribute.

level_name

Name of the level.

level_attribute_name

Name of the level attribute.

wait_for_lock

(Optional) Whether or not to wait for the level attribute 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 22-8  LOCK_LEVEL_ATTRIBUTE 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.

dimension_not_found

Parent dimension not found.

dimension_attribute_not_found

Parent dimension attribute not found.

level_not_found

Parent level not found.

level_attribute_not_found

Level attribute not found.