This content has been marked as final. Show 5 replies
It would be always good to add the gateway init file.
First I would make sure that HS_NLS_NCHAR=UCS2 is present in the gateway init file.
It would be good also to see the source table definition and a gateway trace level 255 when you try to selct one row using the gateway in SQL*Plus.
Edited by: kgronau on Apr 17, 2013 3:12 PM
My gateway init file is after I added the HS_NLS_NCHAR=UCS2 as your reply:
Column Name Data Type Allow Nulls
ID int no
Value int yes
SQL> select * from Table_Name@bob;
For seeing the gateway trace, please use the URL:
HS_LANGUAGE does not make sense when set to UCS2 - please set it to: HS_LANGUAGE=american_america.we8mswin1252
There was an issue a while back using the gateway with mimicked views like all_users etc., but this should have been solved.
Could you please open a SQL*Plus window on your Unix box, connect to the database and execute:
select * from all_users@bob;
Then provide me the output of SQL*Plus
Ok, I have changed it as you wrote:
and I also added the listern.ora:
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = bob))
(HS = OK)
SQL> select * from all_users@bob;
USERNAME USER_ID CREATED
public 0 08-APR-03
dbo 1 08-APR-03
guest 2 08-APR-03
INFORMATION_SCHEMA 3 13-APR-09
sys 4 13-APR-09
db_owner 16384 08-APR-03
db_accessadmin 16385 08-APR-03
db_securityadmin 16386 08-APR-03
db_ddladmin 16387 08-APR-03
db_backupoperator 16389 08-APR-03
db_datareader 16390 08-APR-03
db_datawriter 16391 08-APR-03
db_denydatareader 16392 08-APR-03
db_denydatawriter 16393 08-APR-03
14 rows selected.
The Oracle Warehouse Builder still has the same error by the conversion of character sets.
the env output is missing .. I wanted to check if you have set NLS_LANG in your environment as it has an impact if you for example use NLS_LANG with AL32UTF8 and then start the listener that spawns the gateway. In those cases you have to set the HS_LANGUAGE to american_america.al32utf8 rather then we8mswin1252 (unfortunately a NLS_LANG setting is not visible in 18.104.22.168 gateway trace files)