[ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables

Bugs item #1000639, was opened at 2006-05-09 13:48
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000639&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables

Initial Comment:
Oracle 10g is not able to read the database table names (all_tables and all_objects, es. select * from all_tables(at)hspostgresodbc) from PostgreSQL using PostgreSQL ODBC (v. 08.01.0200). This functionality is essential to be able to use Oracle Warehouse Builder and import external database definitions (heterogeneous services).
However, Oracle (SQL*Plus) is able to retrieve records when the table name is stated in the SQL query (es. select * from “my_table”).
The problem seems to be with the PostgreSQL ODBC because Oracle is able to read schemes from other databases through ODBC. I’ve done some tests with Access dbs just to be sure that the problem is not with my system (Windows XP SP2).
The problem appears both with ANSI and UNICODE PostgreSQL drivers.
Best regards,
Raoni

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000639&group_id=1000125