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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy