Unanswered: Call Oracle procedure using T-SQL (e.g. from sql server stored procedure)
I am writing a Sql Server stored procedure that performs several operations against an Oracle database. Some of these operations could be aggregated into a single Oracle stored procedure, which I have created.
My question is, how can I call the Oracle stored procedure from my Sql Server stored procedure? I have a linked server up and working, but the execute syntax I have tried just doesn't work. I have also tried using the "CALL" command, with no success.
Has anyone done this without resorting to an extended stored procedure? Examples are appreciated!