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?
Two Unix machines, I'd either use jdbc or perl DBI. We have done a lot of
that in
the past. Not a difficult problem.
Sonja Bock
Huntress 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 Tue Aug 28 2001 - 18:33:50 CDT