Oracle DBMS_STREAMS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Database, schema, and object level synchronous and asynchronous replication.
AUTHID CURRENT_USER
Dependencies
ANYDATA DBMS_STREAMS_ADM_UTL GV$STREAMS_APPLY_COORDINATOR
DBMS_APPLY_ADM DBMS_STREAMS_ADM_UTL_INVOK GV$STREAMS_APPLY_READER
DBMS_LOGREP_LIB DBMS_STREAMS_LCR_INT GV$STREAMS_APPLY_SERVER
DBMS_LOGREP_UTIL DBMS_UTILITY GV$STREAMS_CAPTURE
DBMS_STANDARD LCR$_DDL_RECORD USER$
DBMS_STREAMS_ADM LCR$_ROW_RECORD XMLTYPE
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
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_12_2 (new 12.2)
Use with the GET_COMPATIBLE member function for logical change records (LCRs) to specify behavior based on compatibility dbms_streams.compatible_12_2 RETURN INTEGER;
SELECT dbms_streams.compatible_12_2
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
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_PROPAGATION_ADM
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTIL_INT
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved