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 Fri Sep 10 1999 - 14:14:29 CDT
