Unable to invoke stored procedure on MS SQL server

, ,
1

Hi,

I am trying to access a stored procedure residing on MS sql server using JDBC adapter. This stored procedure has 1 input parameter and 3 output parameters.

I tried to configure input/output parameters of stored procedure using JDBC stored procedure ‘Parameter’ tab.

When I run the JDBC stored procedure I get the following error message:

Could not run ‘spGetPlantByProduct’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service IF_SubPurchaseOrder.AdapterServices:spGetPlantByProduct.
[ADA.1.316] Cannot execute the SQL statement “{call srcBoltOndev.dbo.GET_PLANT_BY_PRODUCT (?) }”. "
(HY000/201) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Procedure ‘GET_PLANT_BY_PRODUCT’ expects parameter ‘@PLANT_CODE’, which was not supplied."
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Procedure ‘SRC_GET_PLANT_BY_PRODUCT’ expects parameter ‘@PLANT_CODE’, which was not supplied.

The PLANT_CODE is supposed to be one of the output parameter of stored procedure. Basically JDBC adapter assumes that it needs more than 1 input parameter.

I was able to run the same stored procedure using SQL Analyzer successfully with 1 input parameter.

Did anyone has experience calling a stored procedure which has output parameters.

Any help would be appreciated.

Environment details

IS 6.0.1
MS SQL Server 7.0
JDBC Adapter 6.0.1

Thanks,
krishna

2

Hi,

I found that I configured the JDBC stored procedure wrongly. Corrected it and now its working.

Thanks,
Krishna