SET_PLURAL_NAME Procedure

This procedure sets the plural name of a level.

Syntax

SET_PLURAL_NAME  (
          dimension_owner     IN   VARCHAR2,
          dimension_name      IN   VARCHAR2,
          level_name          IN   VARCHAR2,
          plural_name         IN   VARCHAR2);

Parameters

Table 21-18  SET_PLURAL_NAME Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
level_name	Name of the level.
plural_name	Plural name for the level.

Exceptions

Table 21-19  SET_PLURAL_NAME Procedure Exceptions

Exception	Description
no_access_privileges	User does not have privileges to edit the dimension. User must be the owner or OLAP_DBA.
dimension_not_found	Parent dimension not found.
level_not_found	Level not found.