DBMS_AW , 4 of 9

GETLOG Function

This function returns the session log from the last execution of the INTERP or INTERPCLOB functions in this package.

To print the session log returned by this function, use the DBMS_AW.PRINTLOG procedure.

Syntax

DBMS_AW.GETLOG()
    RETURN CLOB;

Returns

The session log from the latest call to INTERP or INTERPCLOB.

Example

The following example shows the session log returned by a call to INTERP, then shows the identical session log returned by GETLOG.

SQL> SET SERVEROUT ON SIZE 1000000

SQL> EXECUTE DBMS_AW.PRINTLOG(DBMS_AW.INTERP('AW ATTACH xademo; LISTNAMES AGGMAP'));
2 AGGMAPs
------------------------------------------
ANALYTIC_CUBE.AGGMAP.1
XADEMO_SALES_MULTIKEY_CUBE.AGGMAP.1

PL/SQL procedure successfully completed.


SQL> EXECUTE DBMS_AW.PRINTLOG(DBMS_AW.GETLOG());
2 AGGMAPs
------------------------------------------
ANALYTIC_CUBE.AGGMAP.1
XADEMO_SALES_MULTIKEY_CUBE.AGGMAP.1

PL/SQL procedure successfully completed.