ORA-28511 When Selecting From a Large PostgreSQL Table Using DG4ODBC

(Doc ID 949832.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Febl-2013***


A select from a PostgreSQL table with a large amount of data, for example more than 40k, gives the following error -

Select * from large_table@postgres ;
ORA-02068: following severe error from POSTGRES
ORA-28511: lost RPC connection to heterogeneous remote agent using

A select from a table with a small amount of data, for example 4k, using the same DG4ODBC connection works successfully.
The select of the same large Postgres table using DG4ODBC on a different machine may work successfully.

A DG4ODBC trace ends without any errors at the point where it tries to get the remote table information.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms