Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Loading CLOB/BLOB using SqlLoader

Re: Loading CLOB/BLOB using SqlLoader

From: Bart the bear <bartthebear_at_gmail.com>
Date: 2 Dec 2005 10:03:06 -0800
Message-ID: <1133545800.323441.3260@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US