Reg: UTL_FILE vs External Tables vs Pro*C file handling
495532Mar 20 2007 — edited Mar 20 2007Hi,
I am trying to upload a flat file (not the csv or data file) into the database. I can think of the following ways to do this:
1. Use the UTL_FILE package, open it, process it and update the database.
2. Use the external table, dump the file, process it and transfer the processed data to the main tables.
3. Use Pro*C to read, process and update the main tables.
Can you please let me know which among the above one is best interms of performance, reliablity, reprocessing and security?
My file structure would be something like the below:
**** Header Info *****
NAME: XYZABC
ADD1: wewrwe ADD2: ertertert
ADD3: tttttt
PINCODE:4554454 PHONE:222222222
--------
-------
Thanks
Kannan.