Wouldn't the possibility of this happening due to some embedded characters be ruled out due to the fact it also happens with binary data? Oracle BLOB in my first example?

Regarding...

Hello,

No, just the workaround of installing the very old driver for now.

I no longer have an environment with above specs to reproduce the issue. I do think the mentioned steps...

An update if anyone ever finds this post..

I have had contact with Oracle support a lot about this issue after I made this post.

And after doing tests we found out...

It does not match the database version, db version is 18c but when we use the matching driver version we are running into this issue. So we had to go...

Unfortunately our platform currently only support the import by linked server, which I agree is not ideal but I'll have to try to make it work - if possible on...

Yes that works with the Admin user! Thanks a lot Sue, been searching for hours 🙂