I will second this option. I set this up in 10.2 that connects to sql server and it is working fine.IIRC you need ODBC connection so you will need ODBC for Linux/Unix if you work on these platforms.
Adar Yechiel Rechovot, Israel chet justice wrote:
You don't even need Transparent Gateway, you can just use Heterogenous Services.
-- //www.freelists.org/webpage/oracle-l