ODP.NET Managed Driver Incorrectly Truncates String Data When Retrieving It Via DBLINK

(Doc ID 2373421.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

ODP.NET managed driver incorrectly truncates string data when retrieving it via database link.
This problem may occur with the following conditions:

Configuration example:

When connecting directly to DB2, ODPM correctly retrieves 20 characters but when connecting to DB1, it retrieves 13 characters only.

ODP.NET unmanaged driver can retrive whole 20 characters even if it connects to DB1.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms