Re: can this be done - oracle talk to informix - pl/sql or pro*c?

In article <3B866102.1AE40555_at_yahoo.com>, Huntress says...
>
>Hi all,
>I have an Oracle database and an Informix database. They are each on a
>separate Unix machine. What I need to do is make a program that can
>query from both databases. Permissions are not an issue. Is it possible
>to use Pro*C or PL/SQL to talk to an Informix database? It is its own
>query, not in the same query.
>
>Example:
>
>1. Query Oracle DB for all orders that have a certain field filled in.
>2. From those results (for each order returned), query Informix DB for a
>date associated with that order.
>3. Output results to a file.
>
>I am very new to Oracle. Is the above possible? Hints? :)
>
>Thanks!
>~kaeli~

There are gateways:

http://www.oracle.com/gateways/

they permit heterogenous database access (purchased separately).

If you don't want to go that method, you can always load the informix jdbc drivers into Oracle as well and use a java stored procedure (no 2pc or distributed queries -- just access via stored procedures)

Lastly, you can always use a java/jdbc program or a C/odbc program to connect to both and do what you want.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp