Search Results hist_head




Overview
Explore in AI Chat

Overview

CTXSYS.DRICON is a wrapped PL/SQL package body supplied by Oracle Text (the CTXSYS schema), the full-text indexing and search component embedded within the Oracle database that underpins Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package participates in the Domain Index infrastructure, which is the mechanism by which Oracle Text maintains user-defined index types against application tables. DRICON functions as an internal configuration and validation layer, inspecting database metadata to confirm that a candidate column, table, or datastore definition is structurally valid before an Oracle Text index or document data store is created or refreshed. In the EBS context, this package supports the text-search features exposed through the Applications Technology layer, including the indexed search of descriptive flexfield segments, attachments, and other text-bearing columns. It executes under the CTXSYS schema but is invoked indirectly from APPS-tier code and from Oracle Text DDL issued during index maintenance.

Key Procedures and Functions

The package exposes ten documented program units. Their names indicate metadata-validation and data-type introspection responsibilities rather than end-user business logic.

  • SET_DATATYPE_OBJ — registers or assigns the data-type object descriptor used by subsequent validation calls.
  • SET_STORE_OBJ — registers the data-store object descriptor associated with the index configuration under evaluation.
  • GET_DATA_TYPE — returns the resolved data type for the object or column currently in scope.
  • GET_TYPE_DATA_TYPE — retrieves the data type as it pertains to a defined database type, supporting object and collection columns.
  • VALIDATE_TAB — verifies that a referenced table exists and is eligible for the requested Oracle Text operation.
  • EXIST_TAB — performs the existence check for a named table, returning a boolean-style indicator to callers.
  • VALIDATE_TEXT_COLUMN — confirms that a candidate column is a valid text column suitable for indexing.
  • VALIDATE_META_COLUMN — validates a metadata column used by the index to hold filtering or structured attributes.
  • GET_PRIMARY_KEY — resolves the primary key of the target table, required to map indexed documents to their source rows.
  • VALIDATE_CDI — validates the composite or context-dependent index definition, ensuring that its constituent columns and types are coherent.

Tables Accessed

All data dictionary access is performed through APPS-tier synonyms, reflecting the standard EBS practice of granting the applications schema visibility to SYS and CTXSYS objects.

  • DBA_OBJECTS — confirms object existence and object type for the tables and types being validated.
  • DBA_TYPES, DBA_TYPE_ATTRS, DBA_COLL_TYPES — supply type definitions and attribute lists, enabling GET_TYPE_DATA_TYPE to resolve object and collection column structures.
  • DBA_CONSTRAINTS, DBA_CONS_COLUMNS — identify primary key constraints and their constituent columns for GET_PRIMARY_KEY.
  • DUAL — supports trivial single-row queries used during initialization or default resolution.
  • PLITBLM — the Oracle Text index metadata table, used to persist or read index configuration details.

Usage Notes

DRICON is not intended for direct invocation by EBS developers. It is called internally by Oracle Text during the creation, alteration, and synchronization of domain indexes, and is referenced by seven other packages in the CTXSYS schema, which is consistent with its role as a shared validation utility. In EBS 12.1.1 and 12.2.2, activity is typically triggered by concurrent programs that rebuild or optimize text indexes, by DDL executed during patching, and by Applications forms that submit Oracle Text search operations. Custom code should never call these procedures directly; instead, it should rely on the documented Oracle Text DDL and the EBS-supported indexing APIs. Because the package body is wrapped and owned by CTXSYS, support and modification fall outside the Applications DBA's remit and must be handled through Oracle Text patch updates.