Usually, the database vendors maintain and supply their bulk loading utility for a reason - you can't beat sqlldr (or in my case, isql) for their raw loading speed. They are able to circumvent some of the API restrictions that the rest of the database interface needs to follow.
I recommend you look into writing the control file and then shell out to sqlldr to load your data. A templating system will make generating the control file very convenient.
A second route could be to see whether Oracle supports something like LOAD TABLE..., that is, an SQL/DBI interface to sqlldr. That will likely only work on the machine where the database process lives, but you could get a nicer API for error reporting that way than when parsing command output.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||