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

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.