Skip to Main Content
Forums

Oracle Database Discussions

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!

DB link from 11g to SQL Server 2008 and varchar(max) datatype

cardellFeb 15 2011 — edited Mar 9 2011
Hello,
I have "working" database link from Oracle 11g database to SQL Server 2008 using ODBC driver. Almost everything works fine, but I have problem with SQL Server nvarchar(max) datatype.
I can not see columns with this datatype in table column list when I run DESCribe command in SQL*Plus.

I tried some tests and I am able to select this SQL Server datatypes
varchar(8000) -> LONG
text -> LONG
image -> LONG RAW

but I am not able to work with nvarchar(max) and varchar(max) datatype.

I could not find anything about supported datatypes in documentation.

Can you tell me if is possible to use nvarchar(max) column datatype when using ODBC Heterogeneous Connectivity?

Should I use HSODBC or DG4ODBC?

Thank you for answer
This post has been answered by Kgronau-Oracle on Feb 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2011
Added on Feb 15 2011
#11g, #heterogeneous-connectivity, #odbc
5 comments
2,835 views