ORA-28511 When Selecting From a Large PostgreSQL Table Using DG4ODBC
Last updated on JANUARY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 184.108.40.206 [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 -
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
Million Knowledge Articles and hundreds of Community platforms