Execute Oracle procedure from Sql Server
Closed Published by Jordan Ogren December 23rd, 2009 in Geekiness Tags: Microsoft, Oracle, SQL Server.This took me a while to figure out, and there wasn’t good results from Google. So here’s the answer, for those who happen to find this.
EXEC('call Schema.ProcedureName()') at LINKED_ORACLE_SERVER
Make sure you’ve enabled RPC on your linked server too.