469,106 Members | 2,148 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

call a Oracle stored proc in SQL SERVER

v
We have set up Oracle database as a linked server in SQL Server.
We are able to access Oracle tables fine.

I am trying to call a Oracle stored procedure in SQL Server as follows:
declare @p1 varchar(1000)
set @p1 = 'HHH'
exec GENRET..OPS$GENRET.BOB_TEST_PROC @p1

This is the message:
Server 'GENRET' is not configured for RPC.

Please help.
Thanks in advance
v
Jul 20 '05 #1
1 6265
v (va********@yahoo.com) writes:
We have set up Oracle database as a linked server in SQL Server.
We are able to access Oracle tables fine.

I am trying to call a Oracle stored procedure in SQL Server as follows:
declare @p1 varchar(1000)
set @p1 = 'HHH'
exec GENRET..OPS$GENRET.BOB_TEST_PROC @p1

This is the message:
Server 'GENRET' is not configured for RPC.


exec sp_serveroption GENRET, 'rpc', true
exec sp_serveroption GENRET, 'rpc out', true

may be a start.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Eugene A | last post: by
12 posts views Thread by Newbie | last post: by
2 posts views Thread by =?Utf-8?B?Vmlua2k=?= | last post: by
1 post views Thread by =?Utf-8?B?Vmlua2k=?= | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.