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: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 11 Jan 1999 13:09:23 +0800
Message-ID: <36998783.2E2C@bhp.com.au>


Jurij Modic wrote:
>
> 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

I think it is increased to 32k in Oracle 8i ??? --



Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad" Received on Sun Jan 10 1999 - 23:09:23 CST

Original text of this message

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