| 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')); |
