Oracle DBMS_STREAMS
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Database, schema, and object level synchronous and asychronous replication.
AUTHID CURRENT_USER
Dependencies
ANYDATA DBMS_STREAMS_ADM_UTL_INVOK GV$STREAMS_APPLY_COORDINATOR
DBMS_APPLY_ADM DBMS_STREAMS_LCR_INT GV$STREAMS_APPLY_READER
DBMS_LOGREP_LIB DBMS_UTILITY GV$STREAMS_APPLY_SERVER
DBMS_LOGREP_UTIL LCR$_DDL_RECORD GV$STREAMS_CAPTURE
DBMS_STREAMS_ADM LCR$_ROW_RECORD XMLTYPE
DBMS_STREAMS_ADM_UTL    
Documented Yes
First Available 9.2.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
Subprograms
 
COMPATIBLE_10_1
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_10_1 RETURN INTEGER;
SELECT dbms_streams.compatible_10_1
FROM dual;
 
COMPATIBLE_10_2
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_10_2 RETURN INTEGER;
SELECT dbms_streams.compatible_10_2
FROM dual;
 
COMPATIBLE_11_1
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_11_1 RETURN INTEGER;
SELECT dbms_streams.compatible_11_1
FROM dual;
 
COMPATIBLE_11_2
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_11_2 RETURN INTEGER;
SELECT dbms_streams.compatible_11_2
FROM dual;
 
COMPATIBLE_12_1 (new 12.1)
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_12_1 RETURN INTEGER;
SELECT dbms_streams.compatible_12_1
FROM dual;
 
COMPATIBLE_9_2
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_9_2 RETURN INTEGER;
SELECT dbms_streams.compatible_9_2
FROM dual;
 
CONVERT_ANYDATA_TO_LCR_DDL
Converts an ANYDATA object to a SYS.LCR$_DDL_RECORD dbms.streams.convert_anydata_to_lcr_ddl(source SYS.ANYDATA) RETURN SYS.LCR$_DDL_RECORD;
TBD
 
CONVERT_ANYDATA_TO_LCR_ROW
Converts an ANYDATA object to a SYS.LCR$_ROW_RECORD object dbms.streams.convert_anydata_to_lcr_row(source SYS.ANYDATA) RETURN SYS.LCR$_ROW_RECORD;
TBD
 
CONVERT_LCR_TO_XML
Convert a DML or DDL LCR encapsulated in an anydata into an XMLLCR object dbms_streams.convert_lcr_to_xml(anylcr sys.anydata) RETURN SYS.XMLTYPE;
TBD
 
CONVERT_XML_TO_LCR
Convert an XMLLCR object into a DML or DDL LCR encapsulated in AnyData dbms_streams.convert_xml_to_lcr(xmldat sys.xmltype) RETURN SYS.ANYDATA;
TBD
 
GET_INFORMATION
Returns information about various Streams attributes dbms.streams.get_information(name IN VARCHAR2) RETURN SYS.ANYDATA;
SELECT dbms_streams.get_information('SENDER')
FROM dual;
 
GET_STREAMS_NAME
Returns the name of the invoker dbms_streams.get_streams_name RETURN VARCHAR2;
SELECT dbms_streams.get_streams_name
FROM dual;
 
GET_STREAMS_TYPE
Returns the type of the invoker dbms_streams.get_streams_type RETURN VARCHAR2;
SELECT dbms_streams.get_streams_type
FROM dual;
 
GET_TAG
Gets the binary tag for all redo entries generated by the current session dbms_streams.get_tag RETURN RAW;
set serveroutput on

DECLARE
 raw_tag RAW(2000);
BEGIN
  raw_tag := dbms_streams.get_tag;
  dbms_output.put_line('Tag Value = ' || RAWTOHEX(raw_tag));
END;
/

or

SELECT dbms_streams.get_tag
FROM DUAL;
 
MAX_COMPATIBLE
Internal compatible representation dbms_streams.max_compatible RETURN INTEGER;
set serveroutput on

DECLARE
 mc INTEGER;
BEGIN
  mc := dbms_streams.max_compatible;
  dbms_output.put_line(mc);
END;
/
 
SET_TAG
Sets the binary tag for all redo entries subsequently generated by the current session dbms_streams.set_tag(tag IN RAW DEFAULT NULL);
exec dbms_streams.set_tag(HEXTORAW('17'));

Related Topics
Advanced Queuing
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_PROPAGATION_ADM
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS_ADM
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_TABLESPACE_ADM
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved