Problem with unicode DBlink to postgres

Shahmir

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