CREATE_DESCRIPTOR Function

This function creates a descriptor and returns a unique identifier (NUMBER) for the new descriptor.

For each descriptor type, multiple descriptors may be defined. These descriptors are used as a domain to descriptor usages.

This procedure is only available to DBAs.

Syntax

CREATE_DESCRIPTOR (
   descriptor_type       IN   VARCHAR2,
   descriptor_value      IN   VARCHAR2,
   description           IN   VARCHAR2);

Parameters

Table 28-9  CREATE_DESCRIPTOR Function Parameters

Parameter	Description
descriptor_type	Name of the descriptor type. Examples might be dimension type, or attribute type.
descriptor_value	The value for the descriptor. For example, long description and short description are descriptors of type attribute type.
description	Description of the descriptor.

Exceptions

Table 28-10  CREATE_DESCRIPTOR Function Exceptions

Exception	Description
descriptor_type_not_found	Descriptor type must be created first using the CREATE_DESCRIPTOR_TYPE procedure.
descriptor_already_exists	This descriptor value already exists for this descriptor type.
no-access-privileges	Must have OLAP_DBA role.