My Oracle Support Banner

ORA-28501 Using Database Gateway for SQL Server 12C (Doc ID 2013399.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Database Gateway for SQL Server - Version and later
Oracle Database Gateway for DRDA - Version and later
Information in this document applies to any platform.


Using Database Gateway for SQL Server (DG4MSQL) or Database Gateway for DRDA (DG4DRDA) with Oracle Database to connect to SQL Server, produces the following error:

SELECT * FROM owner.activity@gp_proc;

ORA-28501: communication error on heterogeneous database link
ORA-02063: preceding line from GP_PROC

A gateway trace shows the following:

Entered hgotcis at 2015/05/22-12:18:34
Calling SQLStatistics for OWNER.ACTIVITY
IndexType=SQL_TABLE_STAT: cardinality=204
IndexType=1: PK_Activity
Calling SQLColumns for OWNER.ACTIVITY
1 Index(es) found:
Index: PK_Activity, type=1, ASCENDING, UNIQUE, cardinality=204
Error -> Invalid ordinal position for column 'ActivityID': 0
  #1 Column 0: ActivityID
Exiting hgotcis, rc=28501 at 2015/05/22-12:18:34
hostmstr: 140737288609792: HOA After hoxtcis
hostmstr: 140737288609792: RPC After Get Statistics



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.