INTERP function executes one or more OLAP DML commands and returns the session log in which the commands are executed. It is typically used in applications when the 4K limit on output for the
EXECUTE procedure may be too restrictive.
Input to the
INTERP function is limited to 4K. For larger input values, refer to the
INTERPCLOB function of this package.
This function does not return the output of the DML commands when you have redirected the output by using the OLAP DML
You can use the
INTERP function as an argument to the
PRINTLOG procedure in this package to view the session log. See the example.
Note:You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.
INTERP ( olap-commands IN VARCHAR2) RETURN CLOB;
One or more OLAP DML commands separated by semi-colons. See "Guidelines for Using Quotation Marks in OLAP DML Commands".
The log file for the Oracle OLAP session in which the OLAP DML commands were executed.
The following sample SQL*Plus session attaches the
GLOBAL analytic workspace and lists the members of
SET serverout ON EXECUTE dbms_aw.printlog(dbms_aw.interp('AW ATTACH global; REPORT units_cube')); UNITS_CUBE -------------- TIME CUSTOMER PRODUCT CHANNEL