GETLOG Function

This function returns the session log from the last execution of the DBMS_AW.INTERP function, the DBMS_AW.INTERPCLOB function, or the OLAP_TABLE function.

Syntax

The syntax for the GETLOG function is shown below.

DBMS_AW.GETLOG();

Returns

The GETLOG function returns a CLOB session log.

Usage Notes

Effect of the OUTFILE Command

The DBMS_AW.INTERP and DBMS_AW.INTERPCLOB functions do not return the output of the DML commands when you have redirected the output by using the OLAP DML OUTFILE command.

Typical use of the GETLOG Function

Since both the DBMS_AW.INTERP and the DBMS_AW.INTERPCLOB functions return a session log, typically you use the GETLOG function to retrieve the session log in which the OLAP_TABLE function was executed.

Printing the Session Log

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