Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading CLOB/BLOB using SqlLoader
You should use some scripting language to load BLOB column to Oracle.
Loading BLOB's with SQL*Loader is a pain. Scripting languages are
invented
exactly for the tasks like that.
Don't use Perl DBI as it is junk which doesn't support Oracle's array
interface
and is useless for loading big files into the database. The author of
the DBI, Tim Bunce is promoting so called free databases at the expense
of Oracle, by refusing to support array interface in the DBD::Oracle
driver. Look
at the recent thread in perl.dbi.users, he refused to even answer the
questions.
If you are using Oracle, Perl/DBI is not for you. Python is probably
the best
alternative.
Received on Fri Dec 02 2005 - 12:03:06 CST