String Data, Right Truncation With Gateway
(Doc ID 1305506.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for SQL Server - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]Information in this document applies to any platform.
Symptoms
Error occurs when using gateway DG4MSQL 11g:
SELECT "CUSTOMER_ID","CustomerName" FROM "CUSTOMERS"@DBLINK WHERE "CUSTOMER_ID"=1806950;
ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
ORA-02063: preceding 2 lines from DBLINK
Customer_Name datatype is VARCHAR(100)
In the Oracle database NLS_LANG = UTF-8
Result should be;
CUSTOMER_ID CustomerName
----------------- ----------------------------------------------------------------------------------------------------
111111
COMPANYX (LAS TECNOLOG�AS)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |