Problem in callling procedure

• KGJ-Dev

  SSCertifiable

  Points: 5780

  More actions

  April 12, 2010 at 10:24 am

  #386683

  Hi,

  i have created linked server between my sqlserver2008 and Oracle10g.

  the following query is working fine

  select * from openquery (DCCOM,'select * from sample).

  but if i try to call procedure

  select

  * from openquery(DCCOM, '{CALL scott.get_test({resultset 25, OUTPUT})}');

  it gives an error as "

  Msg 7357, Level 16, State 2, Line 1

  Cannot process the object "{CALL scott.get_test({resultset 25, OUTPUT})}". The OLE DB provider "OraOLEDB.Oracle" for linked server "DCCOM" indicates that either the object has no columns or the current user does not have permissions on that object."

  how to solve this issue. please help me in this

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737778

  More actions

  April 12, 2010 at 11:39 am

  #1150214

  It mentions permissions. Your linked server is working, but perhaps that package/module is not one you have rights to call.