external_tables, sql_ldr or utl_file

 

I have to load client csv files data into our oracle db

till nowadays I took pl/sql with ult_file

or sql_ldr

but I think it is much more complicate with sql_ldr because you don't have so much control and logging mechanism

in case of bad input data you can not wirte the errors in the database

or you canot validate the data against the database (zipcode in the file validate with zipcode in database and if not valid write an error in the database)

I know there is a third way with external_tables but I guess it is the same as with sql_ldr - if the data are not good validated the data can not be loaded and just an error is written in the bad log file