DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Chennai, India

    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.

  2. #2
    Join Date
    Dec 2001
    You can write a bit of Java to do this and load it as a Java stored procedure.
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.