how do I insert BLOB to oracle DB using DBI-ODBC?

[sangleweb]

Any one have an example of inserting BLOB (PDF file) into an oracle DB (9i) through DBI-ODBC? TIA

 

[MikeLacey]

Annoying.

I've just upgraded to latest ActiveState Perl, for which loads of modules (inc Net and DBI) are not yet available, time to roll back.

Mike

The options are: fast, cheap and right - pick any two.. &

Want great answers to your Tek-Tips questions? Have a look at faq219-2884

 

[sangleweb]

Please reply about the question above, what you wrote has nothing to do with my inquiry.

 

[stevexff]

I think what he means is that he can't help you until he's done that...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[stevexff]

I can't help either, as I don't have an Oracle DB here. However, 2 seconds on Google results in

http://www.icewalkers.com/Perl/5.8.0/lib/DBI/FAQ.html#5.2 How do I handle BLOB data with DBI?,

which will point you in the right direction.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[sangleweb]

Stevexff,

I've read that already, I can retreive BLOB but not insert or update, there seems to be no article about insert/update BLOB using DBI-ODBC.