Oracle DBMS_CUBE_ADVISE_SEC
Version 18.3

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
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_LOG
DBMS_CUBE_UTIL
What's New In 18c
What's New In 19c

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