Oracle | DBMS_STREAMS_RPC

Oracle DBMS_STREAMS_RPC_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.