Search Results get_index_values

Overview

CTXSYS.DRIPREF is the Oracle Text (formerly interMedia Text / ConText) preference management package. It resides in the CTXSYS schema and exposes the dictionary API used to define, query, and maintain preferences stored in the Text dictionary. In Oracle EBS 12.1.1 and 12.2.2, Oracle Text powers several search and indexing features, most notably the DRI (Document Representation Interface) layer that governs how documents are filtered, lexed, sectioned, and stored for a text index. DRIPREF provides the PL/SQL entry points through which those preference objects are created, populated, queried, and dropped.

The package therefore serves as a control surface for text index behavior. Rather than manipulating dictionary base tables directly, callers invoke DRIPREF procedures to associate named preferences—structured as [OWNER.]PREFERENCE_NAME—with a framework object and to set or clear the attributes that determine index generation and document processing.

Key Procedures and Functions

• GET_OAT_ID — Returns the object-attribute identifier for a given class, object, and attribute name.
• GET_OBJ_INFO — Returns the framework object record for a supplied object name.
• GET_PREF_INFO — Returns the preference record for a named preference, with options for a new preference and ownership checking.
• CREATE_PREFERENCE — Creates a preference bound to a specified framework object.
• DROP_PREFERENCE — Deletes a named preference from the Text dictionary.
• DROP_USER_PREFERENCES — Removes preferences owned by a user.
• SET_ATTRIBUTE — Sets the value of an attribute on an existing preference; this is the routine most commonly cited when configuring index and document-processing options.
• UNSET_ATTRIBUTE — Clears a previously set attribute value.
• SET_PREFERENCES — Applies a set of preference values in bulk.
• RPL_PREFERENCES — Replaces existing preference assignments.
• COPY_PREFERENCES — Duplicates preference definitions.
• GET_DEFAULT_FILTER — Returns the default filter preference.
• ADD_PARTITION_STORAGE / REMOVE_PARTITION_STORAGE — Manage partition-level storage clauses for the index.
• GET_ATTRIBUTE_VALUE — Retrieves the current value of a preference attribute.
• GET_INDEX_VALUES / GET_SUB_INDEX_VALUES — Return index and sub-index parameter values.
• GETPREFCLAOBJ, GETOBJDEFAULT, OPENPREFVALUE — Internal accessors that resolve preference classes, object defaults, and preference values.

Tables Accessed

The documented references resolve through APPS synonyms to DUAL and PLITBLM. DUAL supports scalar lookups and default expressions used throughout the accessor functions. PLITBLM is the Oracle Text dictionary result table used by the preference value and object-attribute query paths, and it is the principal data source returned by the getter routines. Preference definitions themselves are maintained in the CTXSYS Text dictionary, which DRIPREF manipulates on the caller's behalf.

Usage Notes

DRIPREF is not an EBS application API and is not invoked by EBS forms or concurrent programs as part of standard business flows. It is called when Oracle Text indexes are created or altered—typically during installation and configuration of text-enabled search, or in custom code that provisions index preferences programmatically. Because the package is owned by CTXSYS, EXECUTE privilege is normally granted explicitly, and custom callers should qualify the call as CTXSYS.DRIPREF. The metadata records that DRIPREF is referenced by 23 other packages, confirming its role as a shared dependency of the broader Oracle Text preference layer rather than a standalone utility.