GET_LINE procedure

The GET_LINE procedure gets a line of text from a specified file. The line of text does not include the end-of-line terminator. When there are no more lines to read, the procedure throws a NO_DATA_FOUND exception.

Syntax


1  UTL_FILE.GET_LINE ( file , buffer )

Procedure parameters

file
An input argument of type UTL_FILE.FILE_TYPE that contains the file handle of the opened file.
buffer
An output argument of type VARCHAR(32672) that contains a line of text from the file.