Forum Stats

  • 3,824,872 Users
  • 2,260,435 Discussions
  • 7,896,333 Comments

Discussions

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

User_2LXQG
User_2LXQG Member Posts: 1 Green Ribbon

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.