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
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.