Oracle | DBMS_MDX

Oracle DBMS_MDX_UTIL 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 Multi-Dimensional SQL utility for MDX support.

AUTHID CURRENT_USER

Dependencies None

Documented No

First Available 20c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsodbo.sql
{ORACLE_HOME}/rdbms/admin/prvtodbo.plb

Subprograms

FLUSH_CURSORS

Flushes MDX ODBO cursors from memory dbms_mdx_util.flush_cursors; PRAGMA supplemental_log_data(flush_cursors, READ_ONLY);

exec dbms_mdx_util.flush_cursors;

      

      PL/SQL procedure successfully completed.