UTL_FILE , 4 of 18

FOPEN_NCHAR Function

This function opens a file in Unicode for input or output. With this function, you can read or write a text file in Unicode instead of in the database charset. See also "FOPEN Function".

Syntax

UTL_FILE.FOPEN_NCHAR (
   location  IN VARCHAR2,
   filename  IN VARCHAR2,
   open_mode IN VARCHAR2)
  RETURN UTL_FILE.FILE_TYPE;

Parameters

Table 77-6 FOPEN_NCHAR Function Parameters

Parameters Description

Parameters	Description
location	Operating system-specific string that specifies the directory in which to open the file.
filename	Name of the file, including extension (file type), without any directory path information. (Under the UNIX operating system, the filename cannot be terminated with a `/`).
open_mode	String that specifies how the file should be opened (either upper or lower case letters can be used). The supported values, and the `UTL_FILE` procedures that can be used with them are: `r` read text (`GET_LINE_NCHAR`) `w` write text (`PUT_NCHAR`, `PUT_LINE_NCHAR`, `NEW_LINE_`, `PUTF_NCHAR`, `FFLUSH`) `a` append text (`PUT_NCHAR`, `PUT_LINE`_`NCHAR`, `NEW_LINE`, `PUTF_NCHAR`, `FFLUSH`)

location

Operating system-specific string that specifies the directory in which to open the file.

filename

Name of the file, including extension (file type), without any directory path information. (Under the UNIX operating system, the filename cannot be terminated with a /).

open_mode

String that specifies how the file should be opened (either upper or lower case letters can be used).

The supported values, and the UTL_FILE procedures that can be used with them are:

r read text (GET_LINE_NCHAR)

w write text (PUT_NCHAR, PUT_LINE_NCHAR, NEW_LINE_, PUTF_NCHAR, FFLUSH)

a append text (PUT_NCHAR, PUT_LINE_NCHAR, NEW_LINE, PUTF_NCHAR, FFLUSH)