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.
Click Here to Expand Forum to Full Width