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 -> Package UTL_FILE/ writing a line with more than 1023 char/Oracle 7.3.3

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

From: Bruno Plankensteiner <bplank_at_ctp.com>
Date: Thu, 20 May 1999 16:25:13 +0200
Message-ID: <37441B48.B37CF4E0@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:25:13 CDT

Original text of this message

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