| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsstr.sql |
| First Available |
9.2 |
| 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 |
|
|
|
| Security Model |
Execute is granted to PUBLIC |
| 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 (new 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_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; |
| |
| MAX_COMPATIBLE (new 11.2) |
| 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')); |
