Re: Flat File Processing

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 10 Oct 2002 14:35:25 -0700
Message-ID: <92eeeff0.0210101335.2ba8d2e4@posting.google.com>

Andrew Mobbs <andrewm_at_chiark.greenend.org.uk> wrote in message news:<gyf*1swAp_at_news.chiark.greenend.org.uk>...
> Billy Verreynne <vslabs_at_onwe.co.za> wrote:
> >Basically what I would like to know if anyone has done some serious
> >intensive file processing via PL/SQL and if one should consider this as an
> >option instead of using Pro*C.
>

Another option is to use Oracle's built in JVM and java.io api. Java gives you much more flexibility then using UTL_FILE because with Java you can use all File IO functionality. i.e. Read/Write/Append/Copy/Move/Delete/Rename files and directories. Efficiency may not be as good though.

/Rauf Sarwar Received on Thu Oct 10 2002 - 16:35:25 CDT