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 will be available on generic Linux platforms in January and soon on AIX and Windows

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