Oracle DBMS_CUBE_ADVISE_SEC
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Undocumented
AUTHID DEFINER
Dependencies
DBMS_CUBE_ADVICE_SEQ$ DBMS_CUBE_ADVISE DBMS_STANDARD
Documented No
Exceptions
Error Code Reason
ORA-08002 dbms_cube_advice_seq$.currval not yet defined in the session
ORA-20103 invalid cube name, SYS.TAB$
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/olap/admin/prvtcoas.plb
Subprograms
 
COADSEQ_CURRENT
Undocumented dbms_cube_advise_sec.coadseq_current RETURN VARCHAR2;
SELECT dbms_cube_advise_sec.coadseq_current
FROM dual;
       *
ERROR at line 1:
ORA-08002: sequence DBMS_CUBE_ADVICE_SEQ$.CURRVAL is not yet defined in this session
ORA-06512: at "SYS.DBMS_CUBE_ADVISE_SEC", line 221


If you run coadseq_next first returns a "1"
 
COADSEQ_NEXT
Undocumented dbms_cube_advise_sec.coadseq_next RETURN VARCHAR2;
SELECT dbms_cube_advise_sec.coadseq_next
FROM dual;

COADSEQ_NEXT
------------
           1

Related Topics
Built-in Functions
Built-in Packages
DBMS_CUBE
DBMS_CUBE_ADVISE
DBMS_CUBE_LOG
DBMS_CUBE_UTIL
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx