topic Re: Oracle BLOB to MS SQL Server in Talend Studio

Oracle BLOB to MS SQL Server

Anonymous — Sat, 16 Nov 2024 13:12:19 GMT

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

Re: Oracle BLOB to MS SQL Server

Anonymous — Tue, 17 May 2011 20:19:39 GMT

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

Anonymous — Tue, 17 May 2011 20:26:38 GMT

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.