Managing Output in a SQL*Plus Session

SQL*Plus maintains system variables (also called SET command variables) to enable you to set up a particular environment for a SQL*Plus session. You can change these system variables with the SET command and list them with the SHOW command.

In SQL*Plus, the output of stored procedures is sent to the SQL buffer. The default size of the buffer is 2K. The SERVEROUTPUT system variable controls whether or not SQL*Plus displays the contents of the SQL buffer.

When using the OLAP stored procedures, you should set SERVEROUTPUT and extend the size of the buffer to its maximum size.

>set serveroutput on size 1000000

After setting SERVEROUTPUT, use the CWM2_OLAP_MANAGER procedure SET_ECHO_ON to display the output of OLAP procedures.

>execute cwm2_olap_manager.set_echo_on;

Several OLAP packages generate reports. For example, the CWM2_OLAP_VALIDATE package generates a metadata validation report, and the CWM2_OLAP_DELETE package generates a delete command report . For procedures that generate reports or other lengthy output, you should direct the output to a file. Use the CWM2_OLAP_MANAGER procedure BEGIN_LOG.

>execute cwm2_olap_manager.begin_log;