Oracle DBMS_STREAMS_MC_INV
Version 12.2.0.1

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 Returns the next value from STREAMS$_SM_ID.

I can't imagine why someone thought they needed to define a package, header and body, and then wrap it for this. Maybe Oracle is paying for code by the line.
AUTHID DEFINER
Dependencies
DBMS_STREAMS_MC DUAL STREAMS$_SM_ID
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthsmc.plb
 
GET_NEXT_SEQNO
Returns the next value from STREAMS$_SM_ID dbms_streams_mc_inv.get_next_seqno RETURN NUMBER;
SELECT last_number
FROM dba_sequences
WHERE sequence_name = 'STREAMS$_SM_ID';

SELECT dbms_streams_mc_inv.get_next_seqno
FROM dual;

SELECT last_number
FROM dba_sequences
WHERE sequence_name = 'STREAMS$_SM_ID';

Related Topics
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_PROPAGATION_ADM
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_HANDLER_INTERNAL
DBMS_STREAMS_MC
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
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