RE: How to query an oracle table from a mysql database

[Paul DuBois]

At 13:18 -0300 7/7/04, Alonso, Claudio Fabian wrote:
>Hello Steve, hello Victor,
>Thanks for your answers.
>My PHP application needs to see this Oracle table, but as far as I could see
>PHP has problems with Oracle 9.2.0. I got a conection problem and found in
>the PHP's bug database that it isn't currently working.
>As I'm familiar with PHP/MySQL, I'm trying to "see" the Oracle table through
>MySQL.
>That's why I'm thinking on a way to create in MySQL a view (or something
>similar) that refers to an external database table (in this case, Oracle).
>I don't know if this kind of solution is possible, using only MySQL to see a
>remote Oracle table, not including any programming language.

It's not.  You must use a program as a bridge, as people have been suggesting.


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com