Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can this be done - oracle talk to informix - pl/sql or pro*c?
"Huntress" <kaeli96_at_yahoo.com> wrote in message
news:3B866102.1AE40555_at_yahoo.com...
> 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~
No.
You need to buy the Oracle for Informix Gateway.
Hth,
Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 24 2001 - 11:01:56 CDT