Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 15:36:56
|
Rasto Valovic writes "I can't find way to call an Oracle (8) Stored Procedure from an SQL server (7.0) database (Through Linked Server). Procedure have input/output parameters. How can I run this procedure with parameters from Oracle though TSQL? Calling procedure between SQL Servers no problem my code:
declare
@nd varchar(2000),
@returnvalue int
SET @nd=''
{call LinkSrv...test('1',@nd output)}
print @nd
execute @vrat=LinkSrv...test 1,@nd output
print @nd
print @vrat
It's OK, but from Oracle I'm receive message:
Server: Msg 7212, Level 17, State 1, Line 0
Could not execute procedure 'test' on remote server 'LinkOra'.
[OLE/DB provider returned message: The command contained one or more errors]
Thank you
Best regards
Rasto Valovic" |
|
|
|
|
|
Oracle Stored Procedure and MS SQL Server 7.0