Flat File Processing

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 10 Oct 2002 12:18:01 +0200
Message-ID: <ao3k7a$h3r$1@ctb-nnrp2.saix.net>

Oracle 8.1.x and later on HP-UX/Linux/Solaris..

How effective is UTL file ito of performance? If having the choice between doing flat file processing either via Pro*C, or via PL/SQL using UTL file, what would you choose and why? (pretend that SQL*Loader is not an option and that db access is a requirement as part of the processing).

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.

--
Billy

Received on Thu Oct 10 2002 - 05:18:01 CDT