UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2,
max_linesize IN BINARY_INTEGER)
RETURN file_type;
max_linesize: minimum value 1, maximum value 32767
UTL_FILE.PUT_LINE (
file IN FILE_TYPE,
buffer IN VARCHAR2);
The maximum size for an output record is 1023 bytes, unless you specify a larger
value using the overloaded version of FOPEN.
if you want to get more detail,please
Oracle9i Supplied PL/SQL Packages and Types Reference
http://gigabase.idi.ntnu.no/oradoc/nav/docindex.htm
UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2,
max_linesize IN BINARY_INTEGER)
RETURN file_type;
max_linesize: minimum value 1, maximum value 32767
UTL_FILE.PUT_LINE (
file IN FILE_TYPE,
buffer IN VARCHAR2);
The maximum size for an output record is 1023 bytes, unless you specify a larger
value using the overloaded version of FOPEN.
if you want to get more detail,please
Oracle9i Supplied PL/SQL Packages and Types Reference
http://gigabase.idi.ntnu.no/oradoc/nav/docindex.htm