Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
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
Input lines and error messages are echoed to the current outfile or the debugging file specified by DBGOUTFILE.
Input lines and error messages do not appear in the current outfile or in the debugging file. (Default)
Notes
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.
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'