Oracle | DBMS_STREAMS_PUB

Oracle DBMS_STREAMS_PUB_RPC Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented Streams tools granted to PUBLIC

Streams was deprecated 03-Jan-2018 but this package still exists in 21c.

AUTHID CURRENT_USER

Dependencies

DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM	DBMS_STREAMS_DATAPUMP_UTIL
DBMS_PRIV_CAPTURE	DBMS_STREAMS_DATAPUMP	DBMS_STREAMS_RPC

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvthsrp.plb

Subprograms

GET_EXPORT_DML_SCN

MIN_SUPP_LOGGING_ENABLED

NEED_SCN

GET_EXPORT_DML_SCN

Undocumented dbms_streams_pub_rpc.get_export_dml_scn( canon_schema IN VARCHAR2, canon_tablename IN VARCHAR2, cookie IN VARCHAR2, flashback_scn IN NUMBER) RETURN NUMBER;

TBD

MIN_SUPP_LOGGING_ENABLED

Returns 'Y' if minimum supplemental logging is enabled dbms_streams_pub_rpc.min_supp_logging_enabled RETURN VARCHAR2;

SELECT dbms_streams_pub_rpc.min_supp_logging_enabled

      FROM dual;

      

      MIN_SUPP_LOGGING_ENABLED

      ------------------------

      Y

NEED_SCN

Undocumented dbms_streams_pub_rpc.need_scn( db_link IN VARCHAR2, interest_num OUT NUMBER, cookie IN OUT VARCHAR2);

TBD