Problem when calling Stored Procedure (DB2) from Developer

,
1

Hi everybody,
I have a Stored Procedure in DB2, with 6 Inputs and 1 Output. But when calling it from Developer it throws the following error:

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service adapters:insertSolicitud2.
[ADA.1.316] Cannot execute the SQL statement “{? = call DBO.ACESP_INSERTSOLICITUD (?, ?, ?, ?, ?, ?, ?) }”. "
(07001/-313) DB2 SQL Error: SQLCODE=-313, SQLSTATE=07001, SQLERRMC=null, DRIVER=3.57.110"
DB2 SQL Error: SQLCODE=-313, SQLSTATE=07001, SQLERRMC=null, DRIVER=3.57.110

I am using db2simpledatasource adapter. May anyone give me a hand?
Thanks,
Marcelo

2

Hello,

This indicate that the number of parameters is invalid OR the type of the parameters is wrong.

It seems that there is 7 input param in your command and you say that there is only 6 (If each ‘?’ is an input param). Maybe you should search that way.

Regards,
Mathieu

3

Mathieu,
Thanks for your reply. I could solve the problem.
I didn’t know that Stored Procedure Adapter was either for Procedures or Functions. So, I had filled Return Field Name (Call Tab) and Out Parameter (Parameter Tab).
I removed Return Field Name and the problem was solved.

Regards,
Marcelo