Search Results exectrust_ret1




Overview
Explore in AI Chat

Overview

CTXSYS.DRIDISP is an Oracle Text (interMedia) internal PL/SQL package shipped with the CTXSYS schema and exposed through the Oracle E-Business Suite database tier. Oracle Text, formerly known as interMedia Text, provides the full-text indexing and search infrastructure used throughout EBS for seeded search functionality, such as the iStore, Knowledge Management, and various retrieval-enabled DFF and descriptive flexfield search paths. The DRIDISP package functions as the dispatch layer for "trusted" callouts issued from the Oracle Text server process back into the database session. Its primary role is to execute synchronous callout commands, allowing the domain index and text server components to invoke stored procedures dynamically while passing positional arguments and, in some variants, capturing return values.

In the context of EBS 12.1.1 and 12.2.2, DRIDISP is not an application-owned object. It resides in the CTXSYS technical schema and is referenced indirectly whenever a text index, structured document, or user datastore invokes trusted procedural callout behavior. The name "dridisp" reflects its designation as a domain index dispatch routine. Because the package is owned by CTXSYS and carries the RESTRICTED or internal designation typical of Oracle Text internals, it should be treated as a system-supplied dependency rather than an EBS customization point.

Key Procedures and Functions

The documented API surface consists of three callable routines, all designed to perform synchronous trust callouts against a named text index and index partition:

  • EXECTRUST — Executes a synchronous trust callout command. It accepts the index owner, index name, partition name, and a numeric function code, followed by up to ten optional positional arguments. It does not return a value to the caller and is used where a callout side effect (such as invoking a user-defined procedure or datastore routine) is required without a result.
  • EXECTRUST_RET — Performs the same synchronous trust callout but additionally returns two output values through OUT parameters, ret1 and ret2, alongside the same index identification, function code, and optional argument list.
  • EXECTRUST_RET1 — A functional variant of the above that returns a single VARCHAR2 value. It follows the same parameter convention of index owner, index name, partition, function code, and up to ten optional arguments, and is suited to callouts requiring a single scalar result.

The optional arguments (arg1 through arg10) provide a fixed-width argument marshalling interface, reflecting the dynamic nature of text-server callouts where argument meaning is determined by the function code passed at runtime.

Tables Accessed

The ETRM metadata for this package does not document any base tables referenced through APPS synonyms. This is consistent with its nature: DRIDISP acts as a dispatch shim rather than a data-access package. Any table access associated with a callout occurs inside the target procedure named by the index metadata and function code, not within DRIDISP itself. Persistent state relevant to text indexes is maintained in Oracle Text dictionary and dr$ tables under the CTXSYS schema, but these are managed by the text server rather than directly by DRIDISP.

Usage Notes

DRIDISP is invoked internally by the Oracle Text server when a domain index definition specifies trusted callout behavior. In EBS deployments, this occurs transparently during index maintenance, synchronization, and query processing for text-enabled columns. Application developers rarely call these routines directly. When troubleshooting, the package appears in dependency chains of other CTXSYS packages and in call stacks captured during text index operations. Custom code should not bind to or modify DRIDISP; doing so risks invalidating the CTXSYS schema and breaking full-text search across EBS modules. Any observed reference to DRIDISP in EBS logs indicates active Oracle Text callout processing rather than an application-level business call.