Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HSODBC: ORA-02070: database does not support subqueries

kwalterJun 19 2008 — edited Jun 20 2008

I'm using HSODBC and an ODBC-Driver to create a database link form Oracle to Informix.
According to the documentation a select-statement with subquery like
select * from "kw_test1"@DLTEST where "i1" in (select "i1" from "kw_test2"@DLTEST where "c1" = 'TTT');
should work.

But I get the error:
ORA-02070: Datenbank DLTEST unterstützt subqueries in diesem Zusammenhang nicht
Same error, when using a local table in the subselect.

What's going wrong?
When connecting to Informix via the same ODBC-driver but without the gateway, the statement works!

Configuration:
Database-server Oracle 10.2.0.3 (without Patch 5965763) on SLES 9
Oracle Database Gateway for ODBC 11g on Windows XP Pro
DataDirekt ODBC driver for Informix V4.2
Informix V7.31 on Sun OS 8

Thank's for any help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2008

Added on Jun 19 2008

#heterogeneous-connectivity

6 comments

3,698 views