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.
Note:
You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.
GETLOG()
RETURN CLOB;
The session log from the latest call to INTERP or INTERPCLOB.
The following example shows the session log returned by a call to INTERP, then shows the identical session log returned by GETLOG.
EXECUTE dbms_aw.printlog(dbms_aw.interp('AW ATTACH global; REPORT units_cube')); UNITS_CUBE -------------- TIME CUSTOMER PRODUCT CHANNEL EXECUTE dbms_aw.printlog(dbms_aw.getlog()); UNITS_CUBE -------------- TIME CUSTOMER PRODUCT CHANNEL