Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
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.
(Default) Input lines and error messages do not appear in the current outfile or in the debugging file.
Examples
Example 6-26 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 an OUTFILE statement 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'