INTERPCLOB Function

This function executes one or more OLAP DML commands (input as a CLOB) and returns the session log in which the commands are executed.

See Also: For the syntax of individual OLAP DML commands, see Oracle9i OLAP DML Reference help. For a information on analytic workspace objects, see Oracle9i OLAP Developer's Guide to the OLAP DML.

Syntax

The syntax for the INTERPCLOB procedure is shown below.

DBMS_AW.INTERPCLOB ( 
    olap-commands     IN CLOB);

Parameters

Table 10-4  DBMS_AW.INTERPCLOB Function Parameters

Parameter	Description
olap-commands	One or more OLAP DML commands separated by semi-colons.

Returns

The INTERPCLOB function returns a CLOB which is the log for Oracle OLAP session in which the OLAP DML commands were executed.

Usage Notes

Guidelines for Using Quotation Marks in OLAP DML Commands

The SQL processor evaluates the OLAP DML commands, either in whole or in part, before sending them to Oracle OLAP for processing. Follow these guidelines when formatting the OLAP DML commands in the olap-commands parameter:

• Wherever you would normally use single quote (') in an OLAP DML command, use two single quotes (''). The SQL processor strips one of the single quotes before it sends the OLAP DML command to Oracle OLAP.
• In the OLAP DML, a double quote (") indicates the beginning of a comment.

Effect of the OUTFILE Command

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.

Printing the Session Log

To print the session log returned by this function, use the DBMS_AW.PRINTLOG procedure.