INTERPCLOB Function

The INTERPCLOB 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 input for the INTERP function may be too restrictive.

This function does not return the output of the OLAP DML commands when you have redirected the output by using the OLAP DML OUTFILE command.

You can use the INTERPCLOB function as an argument to the PRINTLOG procedure in this package to view the session log. See the example.

Syntax

INTERPCLOB ( 
          olap-commands     IN   CLOB)
     RETURN CLOB;

Parameters

Returns

The log for the Oracle OLAP session in which the OLAP DML commands were executed.

Example

The following sample SQL*Plus session creates an analytic workspace named ELECTRONICS, imports its contents from an EIF file stored in the dbs directory object, and displays the contents of the analytic workspace.

SQL> set serverout on size 1000000
SQL> execute dbms_aw.printlog(dbms_aw.interpclob('AW CREATE electronics; IMPORT ALL FROM EIF FILE ''dbs/electronics.eif'' DATA DFNS; DESCRIBE'));

     DEFINE GEOGRAPHY DIMENSION TEXT WIDTH 12
     LD Geography Dimension Values
     DEFINE PRODUCT DIMENSION TEXT WIDTH 12
     LD Product Dimension Values
     DEFINE TIME DIMENSION TEXT WIDTH 12
     LD Time Dimension Values
     DEFINE CHANNEL DIMENSION TEXT WIDTH 12
     LD Channel Dimension Values
            .
            .
            .
     PL/SQL procedure successfully completed.