error fetching via Postgresql odbc over Oracle Gateway

  • From: Derya Oktay <deryaoktay@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Oct 2009 17:06:56 +0300

Hello All,

I am trying to select and create a table by below SQL statement.


create table VAS_MS.ADC_OTAP as
select * from "adcm"."subscriber_setting_history"@ADCOTAPDB.WORLD;

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Out of memory while reading tuples.;
No query has been executed with that handle
ORA-02063: preceding 3 lines from ADCOTAPDB.WORLD

I am currently using Oracle Gateway 11g and PostgreSQL ODBC 8.0.4.

Have you got any experience about this error.

Sincerely,

Derya.
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » error fetching via Postgresql odbc over Oracle Gateway - Derya Oktay