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

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