Select from oracle db then insert into Mysql

[mdog]

I need to have a script that will pull data out of an Oracle DB that is out on the network and dump it into a msql DB. ( I have a username, password and host string that I put into SQLplus and succesfully get data)

I can currently get data in and out of the Mysql DB, but don't know how to get it out of the Oracle db. Is there a function that will allow me to do this?

thanks for any help.

[bastien]

have you tried the php manual and taking a loook at the oracle section?

Basically what you want to do is to get the resultset out of the oracle db and place it into an array, then iterate thru the array and insert the records into the mysql db