Hi,
I have created a link between oracle and PostgreSQL database. When I execute select I get the following error:
ORA-28511: lost RPC connection to heterogeneous remote agent using
These are the configuration details:
OS: Red Hat Linux 6.7 64-bit
Oracle DB: Oracle Ent Ed 12.1.0.2 64-bit
Gateway: Oracle Gateway for ODBC 64-bit 12.2.0.1.0
DriverName:psqlodbcw.so, DriverVer:12.00.0000
Postgresql DB: Version:17.0.4
HS init params:
HS_FDS_TRACE_LEVEL = 255
HS_FDS_SHAREABLE_NAME = /usr/pgsql-12/lib/psqlodbc.so
HS_LANGUAGE = AMERICAN_AMERICA.AL32UTF8
HS_NLS_NCHAR=UCS2
HS_FDS_DELAYED_OPEN=FALSE
HS_FDS_FETCH_ROWS=1
From trace file:
Exiting hgopars, rc=0 at 2025/09/29-16:39:55
hostmstr: 0: HOA After hoxpars
hostmstr: 0: HOA Before hoxopen
Entered hgoopen, cursor id 1 at 2025/09/29-16:39:55
hgoopen, line 89: NO hoada to print
Many thanks!
Regards
Blagy