Share via

How to select BLOB column from Oracle database using Link Server ?

Anonymous
2023-09-04T08:27:20+00:00

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 ?

Regards

Nawaz

Windows Server | Remote and virtual desktops

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-05T01:26:28+00:00

    Hello Mohammed Nawaz Naushad Ali Shaikh

    Thank you for posting in Microsoft Community forum!

    Based on the description, I understand your question is related to Oracle and SQL server.

    Since there are no engineers dedicated to this topic in this forum, in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in Stack Overflow or Microsoft Q&A, they are designed for developers.

    The product pod User experiences is more related to Remote desktop service, Print server and PowerShell etc.

    Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

    Have a nice day!

    Best regards,

    Karlie Weng

    0 comments