[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
MoazzamAug 26 2011 — edited Aug 26 2011While importing data from SQL Server 2005 to Oracle gateway 11g Release2, i am getting following error:
insert into CSDescr select * from CSDescr@sqlserver
*
ERROR at line 1:
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 SQLSERVER
Oracle database characterset is AL32UTF8
SQLServer database characterset is SQL_Latin1_General_CP1_CI_AS
Following is the configuration in the parameter file for gateway:
HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
HS_NLS_LENGTH_SEMANTICS=CHAR
I think setting the HS_LANGUAGE parameter shall fix the error but I want to know what should be the value of this parameter?