Results for “dbms_capture_adm_ivk”

48 results




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

Overview

SYS.DBMS_CAPTURE_ADM_IVK is a Oracle-supplied PL/SQL package that resides in the SYS schema and holds a VALID status within the E-Business Suite 12.1.1 and 12.2.2 environments. The suffix _IVK follows Oracle's internal naming convention for "invoke" wrapper packages. Rather than exposing a public API directly to end users or application code, DBMS_CAPTURE_ADM_IVK functions as the internal invocation stub for the Oracle Streams capture administration facility, delegating runtime calls from the public administrative interfaces into the underlying engine routines.

In the context of Oracle EBS, this package carries no direct business logic. It is a database-tier Infrastructure component that supports the change-data-capture and replication mechanisms EBS relies upon for features such as Oracle Streams-based data propagation, Advanced Queuing integration, and the log-based capture used by certain data-migration and reporting utilities. The _IVK variant is not intended to be called directly; it exists primarily so that other Oracle packages can invoke capture administration functionality in a controlled and indirect manner.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents no exposed procedures or functions for SYS.DBMS_CAPTURE_ADM_IVK, and classifies the API as OTHER. The package is an internal wrapper rather than a callable public interface, so its documented procedure inventory is empty. Since the metadata does not enumerate any subprograms, no parameter lists or signatures are asserted here. Practically, the package surfaces the capture-administration entry points used internally by the Oracle Streams and XStream stacks, including the routines that create, alter, start, stop, and drop capture processes, obtain capture-related system information, and control capture process state transitions. All such logic is exposed to the database through the public parent package rather than through DBMS_CAPTURE_ADM_IVK itself.

Tables Accessed

No tables referenced through APPS synonyms are documented for this object. As an internal SYS-owned invocation wrapper, DBMS_CAPTURE_ADM_IVK operates almost entirely against fixed Streams data dictionary views and internal SYS dictionary tables that track capture processes, rules, and queue associations. The absence of APPS-synonym table references confirms that the package does not read or write EBS application tables directly and that its scope is confined to the replication infrastructure layer.

Usage Notes

DBMS_CAPTURE_ADM_IVK is not intended for direct invocation by EBS developers, concurrent programs, or Oracle Forms. The dependency metadata shows that it is referenced by several higher-level Oracle packages, including DBMS_CAPTURE_ADM, DBMS_STREAMS_ADM_UTL_INVOK, DBMS_STREAMS_RPC, DBMS_XSTREAM_ADM, and DBMS_XSTREAM_GG_ADM, all of which are themselves part of the Streams and XStream administration stack. Calls therefore normally originate from the public API layers such as DBMS_CAPTURE_ADM or DBMS_XSTREAM_ADM, with _IVK acting as the internal transit point. It also depends on SYS.STANDARD, reflecting its use of core PL/SQL constructs. In EBS 12.1.1 and 12.2.2, DBAs inspecting this package should treat it as a read-only Oracle internal artifact; it should never be modified, recompiled with custom logic, or called from custom code, since doing so risks invalidating the Streams/XStream dependency chain that EBS relies upon for replication and change capture.