question

geoffrey.langdon avatar image
geoffrey.langdon asked

Linked Oracle Server invalid Binary Data sort dependent

Hi, I have SQL Server 2016 SP1 with a linked server Oracle 12c Linked Server. Most queries work fine, but there is an issue with Image data. In some records the binary data is corrupt. I changed from Oracle LOB to CLOB and this works with most entries, but there is an issue with some rows. If I change the sort order, **different rows** are corrupt and the originally corrupt rows are correct. I cant post full details, but one symptom is the magic number for JPEGs is removed from the binary data in invalid rows. Changing the sort order alters which rows are invalid - which to me rules out the Oracle CLOBbing function (I have tried several). If I double the CLOB field in the Oracle Query it is always invalid on one row only regardless of sort order, but not related to file size. Any ideas appreciated! Geoff.
oraclesql serverlinked-serverlinked serversorting
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.