Execute Oracle procedure from 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.