sql server (alternate): 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 (vanishri16@yahoo.com) writes:
[quoted text, click to view]

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

may be a start.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at