Register / Login
JDBC and Relational Databases
how to execute remote oracle stored procedure with parameter in ms sql server
posted 3 years ago
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 "
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
MS SQL SERVER StTORED PROCEDURE
Create stored procedure in hssql
Problem using Callable Statement
Calling a stored procedure for MSSQL 2000?
VARBINARY in sp -how-to