FOPEN function

The FOPEN function opens a file for I/O.

Syntax


1  UTL_FILE.FOPEN ( location , filename , open_mode?  , max_linesize )

Return value

This function returns a value of type UTL_FILE.FILE_TYPE that indicates the file handle of the opened file.

Function parameters

location
An input argument of type VARCHAR(128) that specifies the alias of the directory that contains the file.
filename
An input argument of type VARCHAR(255) that specifies the name of the file.
open_mode
An input argument of type VARCHAR(10) that specifies the mode in which the file is opened:
a
Append to file
r
Read from file
w
Write to file
max_linesize
An optional input argument of type INTEGER that specifies the maximum size of a line in characters. The default value is 1024 bytes. In read mode, an exception is thrown if an attempt is made to read a line that exceeds max_linesize. In write and append modes, an exception is thrown if an attempt is made to write a line that exceeds max_linesize. End-of-line characters do not count toward the line size.