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