Oracle9i OLAP User's Guide Release 2 (9.2.0.2) Part Number A95295-02 |
|
|
View PDF |
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.
You can use the INTERPCLOB
function as an argument to the PRINTLOG
procedure in this package to view the session log. See the example.
The syntax for the INTERPCLOB
procedure is shown below.
DBMS_AW.INTERPCLOB ( olap-commands IN CLOB) RETURN CLOB;
Parameter | Description |
---|---|
|
One or more OLAP DML commands separated by semi-colons. |
The log for 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 olap-commands
parameter:
'
) 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 OLAP DML commands when you have redirected the output by using the OLAP DML OUTFILE
command.
The following sample SQL*Plus session creates an analytic workspace named ELECTRONICS
, imports its contents from an EIF file stored in the dbs
directory alias, 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.