File Reading and Writing Options


A number of options are important during file read and write operations. These options are listed in Table: File Reading and Writing Options.

File Reading and Writing Options

Statement Description
ECHOPROMPT
An option that determines whether or not input lines and error messages should be echoed to the current outfile.
INF_STOP_ON_ERROR
An option that specifies the behavior of Oracle OLAP when an error is reached when reading from a file using the INFILE command
ESCAPEBASE
An option that contains the type of escape that is produced by the INFILE keyword of the CONVERT function.
OUTFILEUNIT
(Read-only) An option that contains the file unit number of the current OUTFILE destination, set by the last OUTFILE command.