Hello everyone,
When I am connecting to POSTGRES db by using DBLINK my select is not correctly show me output:
SQL> select * from "test"@PG;
c�mil�
I think its utf problem. but when I am edit initPG.ora file to this
HS_LANGUAGE = AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR = UCS2
parameter LINK is not working . error is :
SQL> select * from "test"@PG;
select * from "test"@PG
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from PG
error log are:
Exiting hgolofns at 2022/06/23-11:24:38
Failed to load ODBC library symbol: /usr/lib64/psqlodbc.so(SQLGetDescRecW)
Exiting hgolofn, rc=28500 at 2022/06/23-11:24:38
Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:441 ID:Loading ODBC aray of function ptrs
hostmstr: 0: HOA After hoainit
RPC Calling nscontrol(0), rc=0
HOA 06/23 11:24:38.758055000: (hotker_ExecuteRpcs) ncrorpi: status = 0
hostmstr: 0: RPC Before Exit Agent
hostmstr: 0: HOA Before hoaexit
Entered hgoexit
HS Gateway: NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:114 ID:Connection context
hostmstr: 0: HOA After hoaexit
hostmstr: 0: RPC After Exit Agent
====================================
odbcinst -j -q
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/oracle/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8