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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Package UTL_FILE/ writing a line with more than 1023 char/Oracle 7.3.3

Re: Package UTL_FILE/ writing a line with more than 1023 char/Oracle 7.3.3

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Thu, 20 May 1999 15:48:06 +0100
Message-ID: <PbV03.317$kF4.142@news-reader.bt.net>


Please don't shout

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Bruno Plankensteiner <bplank_at_ctp.com> wrote in message news:37441B48.B37CF4E0_at_ctp.com...
> Hi
> I face the following problem with the UTL_FILE package. There is a
> limitation of 1023 characters you can write with the PUT, PUTF, PUT_LINE
> functions. I need to create a file with lines > 1023. In Oracle 8.x
> there is an overloaded function fopen where you can do this. But I can't
> switch to Oracle 8.x.
>
> Do you know a workaround to write lines with more than 1023 characters
> into a file within PL/SQL!
>
> Regards Bruno
>
Received on Thu May 20 1999 - 09:48:06 CDT

Original text of this message

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