JohnNZ - 10:33 am on Aug 7, 2012 (gmt 0)
Please bear in mind I've got limited experience in this area and the timeout issue needs someone with better mySQL skills than me but
You probably need to think of this as two tasks. One a php script to transfer the data, the other a cron task to execute the php script.
The php script would have an INSERT command into the Oracle table using a select statement from the mySQL table. Thinking about it, it may be easier to run this from the Oracle server.
Setting up the cron task is a bit convoluted and differs between hosting interfaces I believe. Check out this quick reference guide - [adminschoice.com...]
I know it's not a full solution but hopefully it will get you underway.