Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file limit of 1023 byte. How avoid it?
On Fri, 08 Jan 1999 00:17:25 GMT, clbeck_at_us.oracle.com (Christopher
Beck) wrote:
>On Thu, 07 Jan 1999 22:17:36 GMT, fn032944_at_flashnet.it wrote:
>
>>HI,
>>I have to write to a file line of 2000 byte. I use utl_file but the
>>limit of 1023 per line makes me problem.
>>How could avoid it?
>>tia
>>Max from Rome
>
>In versions before 8i, there is no other way but to split it up.
>
>But in 8i, the utl_file.fopen function has been extended to
> allow for a max_linesize up to 32K.
>
>from the 8i utl_file spec...
>
>...[SNIPPED QUOTE].....
Nice to hear this information. This limitation has been complained of
quite often, beginning with this forum.
>--
>Christopher Beck
>Oracle Corporation
>clbeck_at_us.oracle.com
>Reston, VA.
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)