Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rs_arwar@hotmail.com (Rauf Sarwar)
Newsgroups: comp.databases.oracle.server
Subject: Re: Flat File Processing
Date: 10 Oct 2002 14:35:25 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <92eeeff0.0210101335.2ba8d2e4@posting.google.com>
References: <ao3k7a$h3r$1@ctb-nnrp2.saix.net> <gyf*1swAp@news.chiark.greenend.org.uk>
NNTP-Posting-Host: 192.198.23.44
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034285725 25519 127.0.0.1 (10 Oct 2002 21:35:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 21:35:25 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163785
X-Received-Date: Thu, 10 Oct 2002 14:35:21 MST (news.easynews.com)

Andrew Mobbs <andrewm@chiark.greenend.org.uk> wrote in message news:<gyf*1swAp@news.chiark.greenend.org.uk>...
> Billy Verreynne  <vslabs@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