| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Streams Remote Procedure Call
Support
Streams was deprecated 03-Jan-2018 but this package still exists in 23ai 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. |