Hi
Normally you can read max 1023 bytes per line of the file. If you want to read larger lines you should use the overloaded version of FOPEN:
UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2,
max_linesize IN BINARY_INTEGER)
RETURN file_type;
greetings
Diederik