ODP.NET Managed Driver Incorrectly Truncates String Data When Retrieving It Via DBLINK
Last updated on MARCH 16, 2018
Applies to:Oracle Data Provider for .NET - Version 184.108.40.206 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
ODP.NET managed driver incorrectly truncates string data when retrieving it via database link.
This problem may occur with the following conditions:
- String data includes some multi-byte characters
- Different characterset is used between the source and the destination of DBLINK
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms