Oracle | DBMS_CUBE_ADVISE

Oracle DBMS_CUBE_ADVISE_SEC Version 23c

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

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;

             *

      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 31

      

      -- 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