Re: UTL_FILE and the limitation of line size 1023 bytes

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: Tue, 07 Mar 2000 19:56:03 GMT
Message-ID: <8a3msh$5eu$1@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 Tue Mar 07 2000 - 13:56:03 CST