For bulk loading data, I recommend looking at the solutions the database provides. Oracle has sqlldr which can bulk-load CSV files and fixed-width files directly and much faster than an INSERT based solution with DBI.

You may need to preprocess the files with Perl to assign the wanted default values or, like in my case, convert 00010101 to null for DATE fields.