Linking Oracle tables to MySQL

[Marty Metras]

I us both Oracle and MySQL.
Oracle is on UNIX and MySQL is on Linux.
I have links between different Oracle database (on different servers) but not to the MySQL databases. I can do this in MS Access with ODBC but am unable to do it from UNIX Oracle & Linux MySQL.
I want to convert a program that create text data from MySQL that I import into the Oracle database to filter the data.

I want to make a direct link in the SQL to get data directlly from the MySQL database from ORACLE.

Kind of like this: Where the 2 tables are one different servers.

Select o.partno, m.partnumber
from oracle.PARTmaster_TABLE o, mysql.partmaster_table m
where o.partno = m.partmeaster;

Is there a was to directly link these to DBs?

Marty