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

I normally work with C++ and stored procedures. I have done this also two ways mentioned above.. 1 - write the queries as stored procedures and invoke them, or 2 - write the queries using your favorite code interface.

Both of these require that you open separate connections to each database.

Check out www.sqlapi.com for a pretty nice C++ interface to both. (I'm just a user, not a vendor or reseller). I am quite happy with that product.

HTH, Jeff

On Fri, 24 Aug 2001 09:13:22 -0500, Huntress <kaeli96_at_yahoo.com> wrote:

>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 Mon Aug 27 2001 - 06:47:11 CDT