Writing in a file

  • From: Alex Octan <alex@xxxxxxxxxxx>
  • To: Oracle I List <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 14 Jul 2010 16:07:41 -0300

Hi there,

I am facing a problem that seems to be simple.
The needed is to write a row in a text file (csv), and depends on the
business requirement, I have to concatenate two lines or more and write in a
file. This line usually can have more than 32K.
What I have done is to use utl_file, but as I have lines with more than 32K,
I get an error from Oracle that says the limit has reached.

Is there any way to workaround, even using another package or feature??

DB version 9i EE
AIX OS

Thanks in advance for any comment.
Alex

Other related posts: