Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file limit of 1023 byte. How avoid it?

Re: utl_file limit of 1023 byte. How avoid it?

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 08 Jan 1999 23:29:21 GMT
Message-ID: <3696929d.512378@news.siol.net>


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)



The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Jan 08 1999 - 17:29:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US