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: Jens Mayer <jmayer_at_ratundtat.com>
Date: Thu, 20 May 1999 14:44:33 GMT
Message-ID: <37441ef6.28557743@news.space.net>


Hi Bruno,

I think you just have to use several PUT(..) per line, don't you ? After the last character in your line call the NEW_LINE-function to insert a CR/LF. (Honestly: I never tried this, because I never needed to create such huge lines, but it sounds well...)

hope this helps,
Jens

On Thu, 20 May 1999 16:17:56 +0200, Bruno Plankensteiner <bplank_at_ctp.com> wrote:

>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:44:33 CDT

Original text of this message

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