hi friends,

please tell how to execute the procedure , which in oracle database, from ms sql

my linked oracle server name : CBSAF.
ORACLE PROCEDURE NAME : CBS_INTERFACE_CLIENTS,
ORACLE LOGIN NAME : EXIM18062012

if i use this execute statement ,

EXEC CBSAF..EXIM18062012.CBS_INTERFACE_CLIENTS1 @CLIENTS_ENTITY @CLIENTS_CODE OUT

While execute the above statement getting "Unspecified Error"

please post how to execute the procedure.

Thanks in Advance