Home > Archive > microsoft.public.sqlserver.server > November 2002 > Executind commands from MSSQL server to Oracle via Linked Service





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Executind commands from MSSQL server to Oracle via Linked Service
Ger

2002-11-29, 4:23 am

Hi all.
I have encountered problem, i can' solve at the moment. May be someone
can offer me solution or advice...
I am to execute some commands to Oracle server from MSSql server(like
call some procedure and insert some data in some tabels).
I've created Linked Server to Oracle, and even was able to get some
data via it. But the executing... I have found a lot of information in
helps and forums about getting information via linked server, but no
information about executing commands or calling procedures. All i've
found is possibility to run function in oracle with use select... but
i can't insert or do smth like this while selecting data from Oracle.
Can anyone give me some advice how can i do this. May be Linked Server
is not useable for this, may be i am to use some other method?
Ger :a960807@ttu.ee
Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net