caliing stored procedure issue

[abhijit]

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

What is get_test? I tried to call a function from SQL Server Express to Oracle 9i database and it worked for me.

I used a different syntax.

select * from openquery(NTEST, 'select callabc(to_date(''10/01/2019'',''mm/dd/yyyy'')) from dual')