Yes it is. You will need to setup a linked server from the SQL Server to the Oracle server.
Then use the three part name of the procedure you want to run. Don't forget the double dot to convert the Oracle three part name into the SQL Server four part name.
When setting up the linked server you will need to make sure that you enable RPC and RPC out. Depending on the Oracle procedure you may need to have <a href="http://itknowledgeexchange.techtarget.com/sql-server/how-to-configure-dtc-on-windows-2003/">MS DTC setup</a> as well as either MS DTC on the Oracle server (if it's running Windows) or the native Oracle Distributed Transaction Coordinator to get it all working correctly.
Last Wiki Answer Submitted: May 10, 2010 2:46 pm by Richonet105 pts.