Results for “dbms_streams_adm_utl_invok”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SYS.DBMS_STREAMS_ADM_UTL_INVOK is a wrapped Oracle-supplied package body that forms part of the Oracle Streams administrative infrastructure shipped with the database release underpinning Oracle E-Business Suite 12.1.1 and 12.2.2. In the EBS context, this package is not an Applications product object; it is owned by SYS and appears in the ETRM inventory as an internally classified API. Its business function is to provide supporting services for the Streams administrative layer — specifically the invocation and routing of administrative operations that would otherwise be exposed through the public DBMS_STREAMS_ADM interface. The "_UTL_INVOK" suffix indicates an internal utility responsible for dispatching or executing administrative calls on behalf of the parent DBMS_STREAMS_ADM package rather than presenting a user-facing API of its own.

Key Procedures and Functions

The ETRM metadata records zero documented procedures or functions for this package body. This is consistent with its nature as an internal helper: the PL/SQL source is delivered in wrapped (obfuscated) form, as evidenced by the "PACKAGE BODY dbms_streams_adm_utl_invok wrapped" declaration and the accompanying encoded payload. Because no callable entry points are documented, no parameter lists are published and none should be assumed. Functionally, the package serves as the invocation bridge used by DBMS_STREAMS_ADM to execute administrative sub-operations. It should be treated as private implementation, not as an integration surface.

Tables Accessed

No tables are documented as being accessed through APPS synonyms. This is expected for a SYS-owned Streams utility: any data dictionary or Streams metadata it touches resides in fixed SYS/Streams-owned objects (for example, capture, propagation, and apply configuration views and tables within the Streams schema), not in EBS application tables. Consequently, this package does not read or write EBS business data, and its activity has no direct impact on Oracle Applications tables. Administrators should not expect any EBS synonym resolution or Applications-level privileges to be required for its operation.

Usage Notes

This package is invoked indirectly. Customers and integrators do not call DBMS_STREAMS_ADM_UTL_INVOK directly; it is reached through DBMS_STREAMS_ADM and its companion APIs when Streams capture, propagation, or apply processes are configured, started, stopped, or altered. The metadata notes that it is referenced by seven other packages, confirming a shared internal role across the Streams administration codebase.

In EBS 12.1.1 and 12.2.2 environments, Streams is sometimes employed for data replication, logical standby, or information-sharing configurations. When such features are exercised, this package participates transparently. Custom code should never reference it, because the wrapped body is version-specific and unsupported for direct use. Any errors surfaced from it should be diagnosed through the publicly documented DBMS_STREAMS_ADM interfaces and Streams diagnostic views. Finally, note that Oracle Streams is deprecated in favour of Oracle GoldenGate; newer EBS deployments and patching strategies increasingly avoid Streams-based replication, further reducing the relevance of this internal package.