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!In answer to my own question, in books online I found the following statement under the topic "External Data and Transact-SQL":
"Stored procedures are supported only against SQL Server data sources."
Ah well, at least I was able to get functions w/input parameters to work...|||Hey...I also have the same issue to be resolved.
Let me know if u are able to solve that...
Cheers !!!
~ HK
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment