UTL_FILE

[lesstjm]

Does anyone know a way to work around the 1023 byte max size of a record that can be written to a file using the utl_file.putf procedure?

[pipo]

since Oracle 8 onwards, there is an overloaded version of fopen :

UTL_FILE.FOPEN(
location IN VARCHAR2,
filemane IN VARCHAR2,
open_mode IN VARCHAR2,
max_linesize IN BINARY_INTEGER)
RETURN file_type;

max_linesize is the max number of characters per line, min value is 1, max is 32767, that way you can write the number of characters you want

[lesstjm]

Thanks for the help. I seems to be working.

[padmam]

Hi, 22nd May 2001 21:23 hrs chennai

You can see all the Functions and procedures and usage of the UTL_FILE package

http://www.elementkjournals.com/dbm/0005/dbm0053.htm

Well fine any how pipo has solved this is for more info on the subject.

Cheers

Padmam

[lesstjm]

It turns out that it is not working. It says that the character string buffer is to small.

[pipo]

well, there is another problem, but when I tested the answer I gave you, I perfectly wrote a 1500 characters buffer ...

DECLARE
file_handle utl_file.file_type;
text varchar2(1600) := '';
BEGIN
file_handle:=utl_file.fopen('C:\TEMP','test.txt','a',30000);
for i in 1 .. 100
loop
text := text || '1234567890ABCDE';
end loop;
utl_file.putf(file_handle,'%s',text);
utl_file.fflush(file_handle);
utl_file.fclose_all;
END;
/