CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_STREAMS
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
First Available 9.2
Dependencies
ANYDATA DBMS_STREAMS_ADM_UTL GV_$STREAMS_APPLY_COORDINATOR
DBMS_APPLY_ADM DBMS_STREAMS_DATAPUMP GV_$STREAMS_APPLY_READER
DBMS_COMPARISON DBMS_STREAMS_LCR_INT GV_$STREAMS_APPLY_SERVER
DBMS_LOGREP_IMP DBMS_UTILITY GV_$STREAMS_CAPTURE
DBMS_LOGREP_LIB LCR$_DDL_RECORD UTL_SPADV
DBMS_LOGREP_UTIL LCR$_ROW_RECORD XMLTYPE
Security Model Execute is granted to PUBLIC with GRANT option
 
COMPATIBLE_11_1 (new in 11g)
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_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_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_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('???')
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;
 
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_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [84 users online]    © 2010 psoug.org