Oracle BLOB to MS SQL Server

One Star

Oracle BLOB to MS SQL Server

I am trying to move BLOB data from Oracle to MS SQL Server. If I choose the data type of byte[], then I am able to move the some BLOB data, but not other BLOB data. For the BLOB data that moves, it only moves with the data type of byte[]. For the BLOB data that does not move, I get the error...
The TDS protocol does not support JDBC datatype 2003
For the data that won't move using byte[], if I choose data type Object, I get the error...
Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
Does anybody have any thoughts on this?
Thanks,
Chris Hansen
One Star SR1
One Star

Re: Oracle BLOB to MS SQL Server

Hi ,
Were you able to solve this?
I have the exact same requirement.
Please let me know your solution - thanks.

Re: Oracle BLOB to MS SQL Server

working with blobs always sucks. search for jdbc+blob to get more backgound about using jdbc and BLOB
Set the datatype to String to retrieve VARCHAR blobs (CLOBS) without the CONVERT error.