Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The ECHOPROMPT option determines if 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.
BOOLEAN
ECHOPROMPT = {YES|NO}
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.
Suppose you want to have all input lines and error messages included in the disk file that contains your output. Set ECHOPROMPT to YES
before issuing an OUTFILE statement that sends the output to the disk file. In the following statements, the disk file is in the current directory object.
ECHOPROMPT = YES OUTFILE 'newcalc.dat'