Re: UTL_FILE and the limitation of line size 1023 bytes

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Wed, 8 Mar 2000 08:53:50 +0100
Message-ID: <8a5158$r51$1@news.inet.tele.dk>

Hi Thomas.

I thought this feature wasn't introduced before 8.1.5? Much to my surprise I checked my 8.0.5.2.1 and it's there so you're absolutely right (as always)!

Finn

Thomas J. Kyte <tkyte_at_us.oracle.com> wrote in message news:8a3msh$5eu$1_at_nnrp1.deja.com...
> In article <38c46733_at_ecn.ab.ca>,
> suisum_at_ecn.ab.ca () wrote:
> > Hi,
> >
> > May be some people ask this before. How can we get around the
> limitation
> > line size 1023 bytes for UTL_FILE?
> >
> > Best regards,
> >
>
> In Oracle8.0.5 and up, you can pass in a number upto 32k to specify the
> linesize in the open call.
>
> prior to that -- there is no workaround, the linesize is fixed at that
> length.
>
>
>
> --
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 08 2000 - 01:53:50 CST