Results for “get_tag”
24 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 forms part of Oracle Streams, the database-resident information sharing and replication infrastructure that has shipped with the Oracle database since release 9i. In the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, the package is owned by SYS and is wrapped, meaning its source is obfuscated and only the public interface documented in the ETRM repository is visible to the EBS application tier. The body implements the logic behind the DBMS_STREAMS specification, providing the programmable interface through which administrators and application code construct, inspect, and convert Logical Change Records (LCRs) and interrogate Streams metadata. Within EBS, DBMS_STREAMS underpins the advanced replication and change-data-capture features used by products that synchronize data between databases, and it is invoked indirectly by EBS data-movement utilities rather than being exposed to end users as a business-facing program.
Key Procedures and Functions
The ETRM metadata documents sixteen callable subprograms, classified under the generic API category OTHER:
- SET_TAG — assigns a tag (a binary identifier) to the current session or transaction, marking changes for downstream Streams processing.
- GET_TAG — retrieves the tag currently associated with the session or a specified change.
- GET_STREAMS_NAME — returns the name of the local or remote Streams component being interrogated.
- GET_STREAMS_TYPE — returns the type classification of a named Streams component, such as capture, propagation, or apply.
- CONVERT_ANYDATA_TO_LCR_ROW — converts an ANYDATA payload into a row-type LCR suitable for apply processing.
- CONVERT_ANYDATA_TO_LCR_DDL — converts an ANYDATA payload into a DDL-type LCR.
- GET_INFORMATION — returns runtime information about the Streams environment, including configuration and status details.
- COMPATIBLE_9_2, COMPATIBLE_10_1, COMPATIBLE_10_2, COMPATIBLE_11_1, COMPATIBLE_11_2, COMPATIBLE_12_1, MAX_COMPATIBLE — a family of boolean compatibility predicates that report whether the current database release meets a given Streams feature level; MAX_COMPATIBLE reports the highest compatible level available.
- CONVERT_XML_TO_LCR — parses an XML representation of a change back into an LCR object.
- CONVERT_LCR_TO_XML — serializes an LCR into its XML representation for transport or storage.
Tables Accessed
The ETRM metadata records no tables referenced through APPS synonyms, and the package is not referenced by any other documented package. This is consistent with a SYS-owned dictionary-level package: its internal reads and writes target fixed Streams dictionary views and tables such as ALL_STREAMS_* and DBA_STREAMS_* metadata, which are not EBS application objects and therefore fall outside the ETRM application-schema mapping. Consequently, no EBS business tables are directly read or written by DBMS_STREAMS.
Usage Notes
DBMS_STREAMS is not invoked from EBS forms or standard concurrent programs by name. It is instead called internally by Oracle Streams capture, propagation, and apply processes, and by higher-level packages such as DBMS_CAPTURE_ADM, DBMS_APPLY_ADM, and DBMS_STREAMS_ADM, which in turn may be driven by EBS replication, cloning, or data-synchronization scripts. Custom EBS extensions that implement change-data-capture or cross-database replication against Release 12.1.1 or 12.2.2 may call the conversion and compatibility functions directly. Because the body is wrapped and version-sensitive, direct calls should be limited to documented subprograms, executed with the appropriate privileges, and validated against the compatibility predicates before use.
-
PACKAGE: SYS.DBMS_STREAMS 12.2.2
-
PACKAGE: SYS.DBMS_STREAMS 12.1.1
-
PACKAGE: SYS.DBMS_STREAMS 12.2.2
-
PACKAGE: SYS.DBMS_STREAMS 12.1.1
-
TYPE: SYS.LCR$_DDL_RECORD 12.1.1
-
TYPE: SYS.LCR$_DDL_RECORD 12.2.2
-
TYPE: SYS.LCR$_ROW_RECORD 12.1.1
-
TYPE: SYS.LCR$_ROW_RECORD 12.2.2