Oracle | DBMS_CUBE_ADVISE

Oracle DBMS_CUBE_ADVISE_SEC Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

COADSEQ_NEXT

COADSEQ_CURRENT

Undocumented dbms_cube_advise_sec.coadseq_current RETURN VARCHAR2;

-- if coadseq_next is 
      not run first



      SELECT dbms_cube_advise_sec.coadseq_current;

             *

      ORA-08002: Sequence DBMS_CUBE_ADVICE_SEQ$.CURRVAL is not yet defined in 
      this session.

      

      -- if coadseq_next is run first

      

      COADSEQ_CURRENT

      ----------------

      000001

COADSEQ_NEXT

Undocumented dbms_cube_advise_sec.coadseq_next RETURN VARCHAR2;

SELECT dbms_cube_advise_sec.coadseq_next;

      

      COADSEQ_NEXT

      -------------

      000001