Oracle DBMS_STREAMS_RPC_INTERNAL
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented
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;
/
 
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;
/
 
WAIT_FOR_INFLIGHT_TXN
Undocumente dbms_streams_rpc_internal.wait_for_inflight_txn(current_scn IN NUMBER);
exec dbms_streams_rpc_internal.wait_for_inflight_txn(8924798);

Related Topics
Advanced Queuing
DBMS_CAPTURE_ADM
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_PROPAGATION_ADM
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTIL_INT
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_TABLESPACE_ADM
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved