|Oracle9i OLAP User's Guide
Release 2 (220.127.116.11)
Part Number A95295-02
This procedure sends a session log returned by the
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:
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.
The syntax for the
PRINTLOG procedure is shown below.
The log of a session.
The following example shows the session log returned by the
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.