Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

Part Number B28126-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

PRINTLOG Procedure

This procedure sends a session log returned by the INTERP, INTERPCLOB, or GETLOG functions of this package to the print buffer, using the DBMS_OUTPUT package in PL/SQL.

When you are using SQL*Plus, you can direct the printer buffer to the screen by issuing the following command:

SET SERVEROUT ON SIZE 1000000

The SIZE clause increases the buffer from its default size of 4K.

If you are using a different program, refer to its documentation for the equivalent setting.

Note:

You cannot execute this procedure from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.

Syntax

PRINTLOG ( 
          session-log     IN   CLOB);

Parameters

Table B-27 PRINTLOG Procedure Parameters

Parameter Description

session-log

The log of a session.


Example

The following example shows the session log returned by the INTERP function.

SQL>set serverout on size 1000000
SQL>execute dbms_aw.printlog(dbms_aw.interp('DESCRIBE analytic_cube_f.profit'));

     DEFINE ANALYTIC_CUBE.F.PROFIT FORMULA DECIMAL <CHANNEL
     GEOGRAPHY PRODUCT TIME>
     EQ analytic_cube.f.sales - analytic_cube.f.costs

     PL/SQL procedure successfully completed.