hi abhijit,

i am using Oracle11g and sqlserver2008. still facing the same issue.

i have tried using sqlserver 2005 also using MSDAORA.getting the error as follows

select * from openquery(DCCOM, '{CALL CCOM.get_test({resultset 25, ReturnVal})}')

error :
OLE DB provider "MSDAORA" for linked server "DCCOM" returned message "Argument name not found for PL/SQL procedure.".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "{CALL CCOM.get_test({resultset 25, ReturnVal})}" for execution against OLE DB provider "MSDAORA" for linked server "DCCOM".

could you please help me in this