Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to call SQL Server stored proc?

Status
Not open for further replies.
Chao

Chao

MIS
Jun 17, 2002
27
0
0
US
I have a dblink from Oracle to SQL Server. I need to be able to call a SQL Server stored procedure and pass it some parameters. Does anybody have any clue how to do this?
 
Sort by date Sort by votes
HI, I suspect that it cannot be done..
There is a world of difference between inserting/updating/deleting/selecting data from a 'foreign' database and running a command on that database..

I could be wrong however ( it won't be the first time) and
other responders may give you the method...


[profile]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
320
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
172
Andrzejek
Andrzejek
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
153
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
147
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
1K
carp
carp

Part and Inventory Search

Sponsor

Back
Top