Hi

Firstly you will need to create a linked server (if you already haven't).

Then follow the blog below.

http://blogs.msdn.com/joaquinv/archive/2008/10/23/execute-oracle-stored-procedure-in-sql-server.aspx