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:20:37 +0200
Message-ID: <37441A35.A07D7FC9@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:20:37 CDT

Original text of this message

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