|Oracle9i OLAP User's Guide
Release 2 (220.127.116.11)
Part Number A95295-02
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.
You can use the
INTERP function as an argument to the
PRINTLOG procedure in this package to view the session log. See the example.
One or more OLAP DML commands separated by semi-colons.
The log file for the Oracle OLAP session in which the OLAP DML commands were executed.
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
') 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.
") indicates the beginning of a comment.
This function does not return the output of the DML commands when you have redirected the output by using the OLAP DML
The following sample SQL*Plus session attaches an analytic workspace named
XADEMO and lists the members of the