| Author |
how to execute remote oracle stored procedure with parameter in ms sql server
|
dineshbalakrishnan kumar
Greenhorn
Joined: Oct 13, 2012
Posts: 1
|
|
hi friends,
please tell me how to execute the oracle stored procedure with parameter in ms sql server.
i have created a oracle linked server ( as CBSAF)
oracle stored procedure : cbs_interface
oracle login name : EXIM18062012
i tried to execute the below query
EXEC CBSAF..EXIM18062012.CBS_INTERFACE(@CLIENTS_ENTITY,@CLIENTS_CODE OUT)
But gettting "Unspecified Error "
|
 |
 |
|
|
subject: how to execute remote oracle stored procedure with parameter in ms sql server
|
|
|