<div>
Did you manage to link your 2 DBs ?<br />
If so, how &nbsp;?<br />
If not, let you begin that way.
</div>


Did you manage to link your 2 DBs ?
If so, how  ?
If not, let you begin that way.

<div>
ok, I do not know how to do that, and keep in mind I can not embed script in the ORACLE side 'database links' &nbsp;I can only operate from the mySQL side
</div>


ok, I do not know how to do that, and keep in mind I can not embed script in the ORACLE side 'database links'  I can only operate from the mySQL side

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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<br />
<br />
UPDATE mySQLdb.table <br />
SET &lt;mySQLdb.table.fieldtoupda<wbr />te&gt; = (<br />
&nbsp; &nbsp; &nbsp; SELECT &lt;ORACLEdb.table.fieldtoget<wbr />&gt;<br />
&nbsp; &nbsp; &nbsp; FROM &nbsp;&lt;ORACLEdb.table&gt;<br />
&nbsp; &nbsp; &nbsp; WHERE &lt;ORACLEdb.table.id&gt; = &lt;mySQLdb.table.id&gt;)<br />
WHERE mySQLdb.table.fieldtoupdat<wbr />e is NULL;<br />
<br />
can I connect to another db from within a mySQL procedure, or do I need to use some different method. &nbsp;Looking for some expert guidance and examples if possible :-)<br />
*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
</div>
</div>


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

UPDATE mySQLdb.table 
SET <mySQLdb.table.fieldtoupdate> = (
      SELECT <ORACLEdb.table.fieldtoget>
      FROM  <ORACLEdb.table>
      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

need to update mySQL table with data from Oracle table.  need code in mySQL procedure or script

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.