What I meant was, what procedure would I use if I wanted to run a SQLServer procedure against an Oracle database.

To do the reverse, you would use Transparent Gateways feature...