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!

ODBC ?MSSQL nvarchar(max) column shows in Oracle as NULL

van DommelenAug 1 2016 — edited Aug 12 2016

MSSQL nvarchar(max) column shows in Oracle as NULL

What do we need to do if we want to see the data from an MSSQL database with type nvarchar(max)?

Using an ODBC connection?

We do

select 'MsSqlColumn" from dbo.MsSqlTable@dbling;

even though there is data in that column we only see NULL values using the database link.

Thanks.

This post has been answered by van Dommelen on Aug 4 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2016

Added on Aug 1 2016

#heterogeneous-connectivity

11 comments

4,813 views