Re: Q: UTL_FILE and 2500 character rows

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. 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
> =======================================================================
Received on Mon Sep 13 1999 - 10:36:27 CDT