Search Results dump_thesaurus




Overview
Explore in AI Chat

Overview

CTXSYS.DRITHSD is a PL/SQL package owned by the CTXSYS schema, the Oracle Text (formerly interMedia Text) dictionary owner that ships with the Oracle database and is surfaced inside Oracle E-Business Suite 12.1.1 and 12.2.2. Its API classification in the E-Business Suite Technical Reference Manual (ETRM) is "OTHER," indicating that it is not an application-facing business API but an internal utility that supports the Oracle Text thesaurus infrastructure. The package name itself, DRITHSD, reflects its role as the "DR" (document retrieval / Oracle Text) "THS" (thesaurus) "D" (dump) utility.

The business function of DRITHSD is to expose the contents of an Oracle Text thesaurus to a caller in a controlled, line-by-line fashion. A thesaurus is a structured set of synonym, antonym, broader-term, narrower-term, and related-term relationships used by Oracle Text to expand or restrict full-text queries. Administrators and DBAs periodically need to inspect, audit, or migrate the contents of such a thesaurus. DRITHSD provides the procedural mechanism that makes this possible by allowing a session to open a thesaurus for reading and then iterate through its logical dump lines.

Within an EBS environment, this package is one of a family of CTXSYS thesaurus utilities and is referenced by one other package in the documented metadata, confirming that it functions primarily as a low-level building block rather than as a directly invoked application API.

Key Procedures and Functions

The ETRM documentation records two public program units for CTXSYS.DRITHSD:

  • DUMP_THESAURUS — A procedure that initializes the package for thesaurus dumping. It accepts the name of the thesaurus to be dumped; if no name is supplied, the DEFAULT thesaurus is used. Calling this procedure prepares the session-level state required for subsequent read operations.
  • NEXT_DUMP_LINE — A function that returns the next dump line from the thesaurus that was previously opened by DUMP_THESAURUS. It returns the line content and signals end-of-data by returning NULL. Because it is a function, it can be called from within SQL and PL/SQL expressions.

The documented source comments state explicitly that NEXT_DUMP_LINE must be called after DUMP_THESAURUS. Any attempt to read lines without first initializing the dump will not produce meaningful output. No additional parameters beyond those shown are documented, and parameter lists should not be assumed from external sources.

Tables Accessed

The ETRM metadata for this object lists no tables referenced through APPS synonyms. This is consistent with the package's architecture: it operates on Oracle Text thesaurus data stored in CTXSYS-owned dictionary tables rather than on E-Business Suite application tables. Consequently, DRITHSD does not read or write EBS transactional or setup data, and it carries no dependency on APPS schema objects. Its data source is the Oracle Text thesaurus definition associated with the named thesaurus passed to DUMP_THESAURUS.

Usage Notes

DRITHSD is an internal database utility and is not typically invoked from Oracle E-Business Suite forms, concurrent programs, or standard application flows. It is most commonly encountered in DBA and Oracle Text administration scripts, in migration or backup routines that need to extract a thesaurus definition as text, and in diagnostic sessions where the contents of a thesaurus must be reviewed. The intended calling pattern is sequential: invoke DUMP_THESAURUS once to open the thesaurus, then call NEXT_DUMP_LINE repeatedly until it returns NULL.

Because CTXSYS objects are owned by the database and are subject to Oracle Database licensing for Oracle Text, any custom code that calls DRITHSD must run under a schema with EXECUTE privilege on the package and appropriate access to the underlying thesaurus. Customizations should avoid wrapping this package in application logic, since its interface and behavior are governed by the database release rather than by EBS patching. The search term "Digital Systems Limited Chennai" does not correspond to any documented attribute of this object; DRITHSD is an Oracle-supplied CTXSYS component delivered with the database tier of EBS 12.1.1 and 12.2.2.