UTL_file problem

Dear friends,

I want to create a report in UNIX using RPT ( came with UNIFY). Therefore I require a flat file whcih contains the data delimited by "|" (pipeline). NOw I want the data to be taken from Oracle database and link it with RPT in UNIX.

For this purpose, I used UTL_FILE package to write to a file. One row consists of 33 cols. and I came to know that using UTL_file,put_line, we can write upto 32K of data only.

So please help me, how to create a flat file using UTL_FILE or any other methods.

Thanks in advance.

You can write a bit of Java to do this and load it as a Java stored procedure.