A custom MySQL UDF is one solution if you are comfortable with C.
Off list question:
What sort of `problem` does PHP have with Oracle 9i that is prohibiting you?
From: Alonso, Claudio Fabian
To: 'Steve Davies'
Cc: ''mysql@stripped' '
Sent: 7/7/04 11:18 AM
Subject: RE: How to query an oracle table from a mysql database
Hello Steve, hello Victor,
Thanks for your answers.
My PHP application needs to see this Oracle table, but as far as I could
PHP has problems with Oracle 9.2.0. I got a conection problem and found
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
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,
I don't know if this kind of solution is possible, using only MySQL to
remote Oracle table, not including any programming language.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql