I need to run a scheduled job to update data in a mySQL database, and must query an ORACLE database to get values for the update.
I am very comfortable coding pl/SQL and would like to just create a procedure in mySQL to query the ORACLE table....basically in this form
SET <mySQLdb.table.fieldtoupdate> = (
WHERE <ORACLEdb.table.id> = <mySQLdb.table.id>)
WHERE mySQLdb.table.fieldtoupdate is NULL;
can I connect to another db from within a mySQL procedure, or do I need to use some different method. Looking for some expert guidance and examples if possible :-)
*Note, I know it's possible to create a database link in ORACLE but there's a lot of red tape for me to embed code in ORACLE as opposed to just querying from mySQL or external