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 ?