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