Oracle | DBMS_STREAMS_RPC

Oracle DBMS_STREAMS_RPC_INTERNAL 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 was deprecated 03-Jan-2018 but this package still exists in 21c but not installed by default

AUTHID DEFINER

Dependencies

DBMS_CAPTURE_ADM	DBMS_FLASHBACK	DBMS_STREAMS_RPC
DBMS_CAPTURE_ADM_INTERNAL

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

BUILD

GET_SYSTEM_CHANGE_NUMBER

WAIT_FOR_INFLIGHT_TXN

BUILD

Undocumented

Must be in archive log mode to use this procedure dbms_streams_rpc_internal.build(frst_scn OUT NUMBER);

DECLARE

       scnVal NUMBER;

      BEGIN

        dbms_streams_rpc_internal.build(scnVal);

        dbms_output.put_line(TO_CHAR(scnVal));

      END;

      /

      37371961

      

      PL/SQL procedure successfully completed.

GET_SYSTEM_CHANGE_NUMBER

Undocumented dbms_streams_rpc_internal.get_system_change_number(scn OUT NUMBER);

DECLARE

       scnVal NUMBER;

      BEGIN

        dbms_streams_rpc_internal.get_system_change_number(scnVal);

        dbms_output.put_line(TO_CHAR(scnVal));

      END;

      /

      37372733

      

      PL/SQL procedure successfully completed.

WAIT_FOR_INFLIGHT_TXN

Undocumented dbms_streams_rpc_internal.wait_for_inflight_txn(current_scn IN NUMBER);

exec dbms_streams_rpc_internal.wait_for_inflight_txn(37372733);

      

      PL/SQL procedure successfully completed.