Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ECHOPROMPT

The ECHOPROMPT option determines whether or not input lines and error messages should be echoed to the current outfile. When ECHOPROMPT is set to YES and you have specified a debugging file with DBGOUTFILE, the input lines and error messages are echoed to the debugging file instead of the current outfile.

Data type

BOOLEAN

Syntax

ECHOPROMPT = {YES|NO}

Arguments

YES

Input lines and error messages are echoed to the current outfile or the debugging file specified by DBGOUTFILE.

NO

Input lines and error messages do not appear in the current outfile or in the debugging file. (Default)

Notes


ECHOPROMPT

The ECHOPROMPT option causes input, as well as error messages, to be echoed to the current outfile, or to the debugging file when there is one.


Current and Default Outfiles

The current outfile is the destination for the output of statements, such as REPORT and DESCRIBE, that produce text. When you have not used the OUTFILE command to send output to a file, Oracle OLAP uses your default outfile.

Examples

Example 11-16 Using ECHOPROMPT

Suppose you want to have all input lines and error messages included in the disk file that will contain your output. Set ECHOPROMPT to YES before issuing the OUTFILE command that will send the output to the disk file. In the following statements, the disk file is in the current directory object.

ECHOPROMPT = YES
OUTFILE 'newcalc.dat'