Oracle | DBMS_CUBE_ADVISE

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

COADSEQ_NEXT

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