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?
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 ??? --
![]() |
![]() |