Search Results dbms_streams_pub_rpc




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_PUB_RPC is an Oracle-supplied PL/SQL package body residing in the SYS schema. Its name reflects its role as the public Remote Procedure Call (RPC) interface layer for the Oracle Streams publishing infrastructure. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package forms part of the underlying database technology stack that supports change data capture, replication, and event publishing mechanisms leveraged by EBS features such as Business Events, Oracle Advanced Queuing integrations, and the EBS Audit Trail / Sign-On Audit propagation components.

The package is documented in the ETRM with a status of VALID and is classified in the API category OTHER, indicating it is an internal infrastructure package rather than a formally exposed EBS application programming interface. It is not referenced by any other database object, which confirms its position as a top-level entry point invoked directly by external callers, background processes, or administrative routines rather than being nested within another PL/SQL construct.

Key Procedures and Functions

The ETRM metadata documents zero named procedures or functions associated with this package body. This is typical of internal Oracle Streams RPC packages, whose callable units are registered dynamically with the Streams propagation and apply engines rather than being catalogued for external developers. The absence of a documented procedure list does not indicate that the package is empty; rather, it indicates that its entry points are consumed by the Streams runtime and not intended for direct invocation by EBS application code.

Functionally, packages of this class expose remote procedure call handlers that allow a Streams client process to publish messages, acknowledge receipt, or query publish state across a database link. Because no parameter signatures are documented, no parameter-level detail is asserted here.

Tables Accessed

The metadata does not document any underlying tables accessed through APPS synonyms, nor any base tables owned by SYS that this package reads or writes. As a Streams RPC layer, its runtime behaviour operates principally against Streams dictionary views and internal queue infrastructure rather than against EBS application tables. Users should therefore not expect this package to touch EBS transactional tables such as FND_LOGINS or WF_ business event tables directly; any such interaction occurs indirectly through the Streams capture and apply processes configured elsewhere.

Usage Notes

DBMS_STREAMS_PUB_RPC references several sibling packages, including DBMS_STREAMS_ADM, DBMS_STREAMS_DATAPUMP, DBMS_STREAMS_DATAPUMP_UTIL, DBMS_LOGREP_UTIL, DBMS_PRIV_CAPTURE, and STANDARD. These dependencies confirm that the package participates in Streams administration, Data Pump-based export/import of Streams metadata, log replication utilities, and privilege capture.

  • Invocation is normally indirect: the Streams propagation job or apply process calls the RPC handlers in place of direct application code.
  • Custom code should not call this package directly; Oracle does not document its entry points and they may change between patch set updates or releases.
  • Database administrators may encounter this object when diagnosing Streams propagation failures, invalid object reports, or when compiling dependent SYS packages after a database upgrade.
  • Because the package is not referenced by any other database object, invalidation of DBMS_STREAMS_PUB_RPC will not cascade to EBS application packages, but it can impair Streams-based replication and event delivery.
  • Standard maintenance is limited to ensuring the package remains VALID and that the underlying Streams configuration is licensed and enabled where used.