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

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~ Received on Fri Aug 24 2001 - 09:13:22 CDT