Results for “dbms_streams_handler_internal”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SYS.DBMS_STREAMS_HANDLER_INTERNAL is an Oracle-supplied internal PL/SQL package that resides in the SYS schema and forms part of the underlying infrastructure supporting Oracle Streams and its successor, the Oracle Advanced Queuing based apply/streams handler framework. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is not an EBS application object and carries no direct business logic. Instead, it functions as a low-level handler management utility that supports the plumbing used by Streams-based data propagation and apply processing that EBS historically leveraged for features such as Oracle Advanced Queuing (AQ), Business Event System (BES) message propagation, and distributed data synchronization.
The package is documented with status VALID, an owner of SYS, and an API classification of OTHER. The ETRM metadata records no exposed procedures or functions, reflecting its internal, undocumented nature. Its principal role is to provide protected helper routines consumed by higher-level exposed packages rather than being invoked directly by application code.
Key Procedures and Functions
The ETRM documentation excerpt for this object lists zero documented procedures and functions. Consistent with its naming and dependency profile, DBMS_STREAMS_HANDLER_INTERNAL contains only internal, non-public routines that are not exposed for customer or application use. Because no parameter lists are documented, no specific signatures can be stated. Functionally, the package is understood to provide helper operations for managing and dispatching Streams handlers — the callbacks that process captured or propagated messages — which are wrapped by the public administrative packages listed in the dependency information. Direct invocation is neither supported nor required.
Tables Accessed
The ETRM metadata does not enumerate specific tables referenced through APPS synonyms for this package. As a SYS-owned internal package, DBMS_STREAMS_HANDLER_INTERNAL operates primarily against data dictionary and Streams metadata views and base tables rather than EBS application tables. Any reads or writes it performs are confined to the Streams runtime and rule/handler metadata used to coordinate apply processing, not to EBS transactional schemas.
Usage Notes
DBMS_STREAMS_HANDLER_INTERNAL is referenced by four higher-level packages: DBMS_APPLY_ADM_INTERNAL, DBMS_APPLY_HANDLER_ADM, DBMS_APPLY_HANDLER_INTERNAL, and DBMS_STREAMS_HANDLER_ADM. These dependents are the administrative and internal layers that EBS and the database invoke to configure Streams apply processes, register handlers, and manage rule sets. The dependency chain confirms that this package sits at the bottom of the handler stack, providing shared internals to those callers.
In EBS environments, this package is typically exercised indirectly through AQ and Business Event System activity, Streams-based replication, or database maintenance performed by Oracle-supplied scripts and internal database jobs. It is not intended for direct call from EBS Forms, concurrent programs, or custom PL/SQL. Because it is internal and undocumented, EBS developers and DBAs should treat it as a protected object: it should never be modified, and custom code should rely only on the documented public packages. Its presence in ETRM is chiefly of diagnostic value, indicating the Streams handler dependency chain present in the database supporting EBS 12.1.1 and 12.2.2.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1