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:48:27 +0200
Message-ID: <374420BB.E9C9D47A_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 - 16:48:27 CEST

Original text of this message