Results for “compatible_10_2”

6 results




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

Overview

SYS.DBMS_STREAMS is an Oracle-supplied PL/SQL package that exposes the application programming interface for Oracle Streams, the database-level information sharing and replication infrastructure built into the Oracle RDBMS kernel. In Oracle E-Business Suite Release 12.1.1 and 12.2.2, the package is owned by SYS and carries a VALID status in the data dictionary. It is not an EBS-authored API; rather, it is a core database component that surfaces inside the EBS schema dependency graph because Oracle Streams underpins several data propagation and capture mechanisms used by the E-Business Suite. The package provides the runtime entry points used to interrogate and manipulate the Streams environment, including tag management, Streams name and type resolution, datatype conversion between XML and Logical Change Records (LCRs), and compatibility checks against database release levels. Its documented API classification within ETRM is OTHER, reflecting that it is a database utility package rather than a functional EBS business API.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions, grouped by purpose:

  • Tag management: SET_TAG and GET_TAG. These establish and retrieve the session-level tag value that Oracle Streams uses to identify and filter the source of redo changes, allowing capture and apply processes to distinguish changes originating from specific sessions or components.
  • Streams identification: GET_STREAMS_NAME and GET_STREAMS_TYPE. These resolve the name and type of an active Streams object, supporting dynamic discovery of capture, propagation, and apply components.
  • LCR conversion: CONVERT_ANYDATA_TO_LCR_ROW, CONVERT_ANYDATA_TO_LCR_DDL, CONVERT_XML_TO_LCR, and CONVERT_LCR_TO_XML. These translate between the internal ANYDATA/XML representations and the strongly typed LCR$_ROW_RECORD and LCR$_DDL_RECORD objects, enabling row and DDL changes to be inspected, transformed, or serialized.
  • Diagnostics: GET_INFORMATION. This returns descriptive metadata about a Streams component, supporting operational troubleshooting.
  • Compatibility checks: COMPATIBLE_9_2, COMPATIBLE_10_1, COMPATIBLE_10_2, COMPATIBLE_11_1, COMPATIBLE_11_2, COMPATIBLE_12_1, and MAX_COMPATIBLE. These return Boolean or version indicators reflecting the database compatibility level, allowing callers to branch behavior across supported release boundaries spanning 9.2 through 12.1.

Tables Accessed

The ETRM metadata does not document any base tables accessed through APPS synonyms for this package. This is consistent with its nature: DBMS_STREAMS operates against internal Streams dictionary views and fixed objects rather than against EBS application tables. Its documented dependencies are entirely on SYS-owned types — ANYDATA, XMLTYPE, LCR$_DDL_RECORD, LCR$_ROW_RECORD, and STANDARD — rather than on application data structures.

Usage Notes

DBMS_STREAMS is referenced by PUBLIC (via the synonym DBMS_STREAMS) and by SYS, and the metadata records zero referencing packages within the EBS schema, indicating that EBS functional code does not invoke it directly. In practice it is called from the database tier during Streams configuration, capture and apply process maintenance, and diagnostic sessions, often issued from SQL*Plus or administrative scripts executed by a DBA. Organizations running EBS on 12.1.1 or 12.2.2 may encounter the package when diagnosing Streams-based replication used for reporting databases, data guard complement, or custom propagation. Because the package requires elevated privileges and affects kernel-level replication behavior, it should not be invoked from EBS Forms, concurrent programs, or custom application code without explicit DBA oversight.