Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, August 27, 2013

Column with NVARCHAR(4000) not appearing in Resultset using DG4MSQL

Problem:
On SQL Server side a table had a column (desc_details) with NVARCHAR(4000), DG4MSQL has been configured for communication with SQL Server. Querying to that table was not showing the column (desc_details) but all other columns were being shown correctly.


Solution:
workaround:
After a closer look at the definition of table (SQL Server side), found that only this column had NVARCHAR(4000) so just requested SQL Server team to have NVARCHAR(2000) for this column instead as a quick test. It worked.

Remedy:
Add the below parameters to the gateway initdg4msql.ora file , restart the gateway listener and check again.

HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR=UCS2
 

No comments: