July 11, 2008 at 8:21 am
My customer is considering set up Linked Servers to Oracle10g to address some CLR/ADO.net problems that we are having. Although I have used Linked Server connections to other SQL Servers, I do not know a lot about what you can and cannot do with a Linked Server to Oracle.
My immediate question is can I run a stored procedure, remotely on an Orcale server from SQL Server through a Linked Server connection? Like:
EXEC OraclLink.Dev.spAddOrderInfo @OrderID, @NewDate, NewPart
Thanks,
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 12, 2008 at 12:08 am
I found this information helpful:
http://p2p.wrox.com/topic.asp?TOPIC_ID=1554
Best Regards,
Chris Büttner
July 12, 2008 at 4:40 pm
Is that the right site? It doesnt seem to have anything to do with my questions?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 13, 2008 at 10:35 am
Sorry, the 2 at the end seems to have dropped off from the link.
Use http://p2p.wrox.com/topic.asp?TOPIC_ID=15542 instead.
Best Regards,
Chris Büttner
July 13, 2008 at 11:33 am
Thanks, Christian, that was helpful.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply