ORA-29285 with utl_file.fopen 1

[jestrada101]

When writing to the file works fine with

Open my file like this...
utl_file.fopen ('TESTA',filename, 'A')

I write to file like this...
utl_file.put_line (output_file,MyVarData);

ERROR at line 1:
ORA-29285: file write error
ORA-06512: at "SYS.UTL_FILE", line 18

It only seems to be a problem when the string of MyVarData is very long.. over 2000 characters.

Any ideas?

 

[SantaMufasa]

J,

For what it is worth, my tests show that I can successfully output 1,022 characters with "utl_file_put_line", but if I attempt 1,023 characters, it blows with the same error you received. I also tried to "stage" data in pieces, then "flush" the data, but I still ran into the same 1,022-characters-total limitation.

It would be an interesting experiment to see if your limitation is precisely the same 1,022 characters as mine. If not, then there may be some method to alter the output maximum.

Let me know.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:27 (02Dec04) UTC (aka "GMT" and "Zulu"),
@ 10:27 (02Dec04) Mountain Time

 

[sem]

I suppose that this limit may be related to CRLF (CHR(13)||CHR(10)) symbol at the end of line.

Regards, Dima

http://seminihin.narod.ru

 

[jestrada101]

I tested at 1022 and 1023 characters and you are right, this is the failing point. Hmm... guess I'll keeptrying to research how to extend this somehow.

 

[SantaMufasa]

J,

Eureka !!! I found and tested a solution for you. Add one more parameter onto your "utl_file.fopen" function:

:=	utl_file.fopen(
					location => path,
					filename => filename,
					open_mode => read_write_append,
					[b]max_linesize => 32767[/b]);

This allows you to go up to 32K of output per line and there is no penalty. Recommendation is, use "max_linesize => 32767" for each utl_file.fopen.

Let us know how it works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 18:40 (03Dec04) UTC (aka "GMT" and "Zulu"),
@ 11:40 (03Dec04) Mountain Time

 

[jestrada101]

Perfect!!! Thanks... I actually seen where it would take that last argument, but did not know to put the "=>".

Many thanks!
Jose E