Oracle | DBMS_STREAMS_PUB

Oracle DBMS_STREAMS_PUB_RPC Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented Streams tools granted to PUBLIC

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai

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, else N dbms_streams_pub_rpc.min_supp_logging_enabled RETURN VARCHAR2;

SELECT dbms_streams_pub_rpc.min_supp_logging_enabled;

      

      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