Re: Q: UTL_FILE and 2500 character rows

A copy of this was sent to "Dr. Gerald Kilgus" <gerald.kilgus_at_merck.de> (if that email address didn't require changing) On Mon, 13 Sep 1999 17:36:27 +0200, you wrote:

>We have solved the problem in the same way Scott described it (.i.e.
>cutting the output into pieces and
>glueing it together with a "postprocessing" C-Utility).
>I would be grateful to have a more elegant solution completely within
>PL/SQL.
Until Oracle8i, release 8.1, UTL_FILE has this hard limit. In 8.1, you can set the linesize upto 32k.

In Oracle8.0, you could write an extproc in C to do this as well (but thats not all in plsql).

>Cheers
>
>Gerald Kilgus
>
>------------------------------------------------------------------------------------------------
>
>
>
>Chad Thompson wrote:
>
>> I've run into a problem with UTL_FILE writing a file. I need to
>> write several thousand rows to a flat file, all 2500 characters per
>> row. PUT_LINE has a max of 1023 characters, and combining multiple
>> PUT with FFLUSH still dies at 1k characters. I've also tried
>> OPEN/PUT/FFLUSH/CLOSE and tried to append each time, but each append
>> starts on a new line.
>> Anyone have an idea where I'm making a mistake, or how to write out
>> a flat file of 2500 characters per row in a PLSQL package? It's not
>> something that can be manually spooled in SQLPlus.
>>
>> --
>> ======================================================================
>> Programmer Analyst: Oracle HRMS, Security Apps
>>
>> Chad Thompson
>> thomp901_at_cs.uidaho.edu
>> http://www.uidaho.edu/~thomp901
>> =======================================================================

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 13 1999 - 12:15:27 CDT