Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Package UTL_FILE/ writing a line with more than 1023 char/Oracle 7.3.3
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