Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
UTL_FILE problems
- Thread starter fmsousa
- Start date
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
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
- Status