A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
how to execute remote oracle stored procedure with parameter in ms sql server
Joined: Oct 13, 2012
Oct 13, 2012 05:59:14
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 "
I agree. Here's the link:
subject: how to execute remote oracle stored procedure with parameter in ms sql server
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015