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

[Erland Sommarskog]

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