Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is the best approach to resolving Microsoft nvarchar(max) issue with Oracle query over DBLink

TssyOJun 6 2022

Hello,
Does anyone know how to resolve MS SQL Server nvarchar(max) when pulling data via Oracle database link - this table has columns declared as nvarchar(max). We are getting "Invalid column" error for those columns declared as such. Is there any working/knw solution to this issue? Our environment is 12c or above. Can someone assist with this? Thanks in advance.

Comments
Post Details
Added on Jun 6 2022
4 comments
1,602 views