Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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.PRINTLOG ( session-log IN CLOB);
The following example shows the session log returned by the INTERP
function.
SET serverout ON size 1000000 EXECUTE dbms_aw.printlog(dbms_aw.interp('REPORT W 30 all_dimensions')); ALL_DIMENSIONS ------------------------------ TIME.DIMENSION CUSTOMER.DIMENSION PRODUCT.DIMENSION CHANNEL.DIMENSION