How to select BLOB column from Oracle database using Link Server in SQL server 2019 DB ?

Nawaz 1 Reputation point

I have created a Link from SQL server 2019 to Oracle database 19c. Every thing works fine. But when I am selecting the BLOB columns from Oracle, the results are mixed up and shows wrong data. I have done cast BLOB as varbinary max is well. I do cast or no cast it doesnt matters, results are alwyz showing wrong.

Is there any different way of selecting BLOB columns from Oracle using Link Server ?



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,924 questions
{count} votes