Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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.
INTERPCLOB ( olap-commands IN CLOB) RETURN CLOB;
Table B-25 INTERPCLOB Function Parameters
Parameter | Description |
---|---|
|
One or more OLAP DML commands separated by semi-colons. See "Guidelines for Using Quotation Marks in OLAP DML Commands". |
The log for the Oracle OLAP session in which the OLAP DML commands were executed.
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.
SET serverout ON size 1000000 EXECUTE dbms_aw.printlog(dbms_aw.interpclob('AW ATTACH global; DESCRIBE')); DEFINE GEN_OBJ_ROLES DIMENSION TEXT DEFINE GEN_AW_OBJS VARIABLE TEXT <GEN_OBJ_ROLES> DEFINE ALL_DIMENSIONS DIMENSION TEXT DEFINE DIM_OBJ_LIST DIMENSION TEXT DEFINE DIM_AW_OBJS VARIABLE TEXT <ALL_DIMENSIONS DIM_OBJ_LIST> . . .