Making an ODBC call from an ORACLE Stored Procedure

Hi,

I was wondering if anyone can help me.

I need to connect to an ODBC resource, but I need to do it from an ORACLE stored procedure or function. Not from a client web page.

I know this is not typical but I need to do it.

I will set up the DSN ... but again I need ORACLE (stored procedure or function) to make the connection.

Any help will be greatly appreciated. Please email me.

[email protected]

Thanks