FOPEN Function

This function opens a file. With this version of FOPEN, you can specify the maximum line size. The other version of the "FOPEN Function" uses the default line size. You can have a maximum of 50 files open simultaneously.

See also "FOPEN_NCHAR Function".

Syntax

UTL_FILE.FOPEN (
   location     IN VARCHAR2,
   filename     IN VARCHAR2,
   open_mode    IN VARCHAR2,
   max_linesize IN BINARY_INTEGER) 
  RETURN file_type;

Parameters

Table 77-4 FOPEN Function Parameters

Parameter	Description
location	Directory location of file.
filename	File name (including extension).
open_mode	Open mode (r, w, a).
max_linesize	Maximum number of characters per line, including the newline character, for this file. (minimum value 1, maximum value 32767).

Returns

Table 77-5 FOPEN Function Returns

Return	Description
file_type	Handle to open file.

Exceptions

INVALID_PATH: File location or name was invalid.
INVALID_MODE: The open_mode string was invalid.
INVALID_OPERATION: File could not be opened as requested.
INVALID_MAXLINESIZE: Specified max_linesize is too large or too small.