Hi

Am new to webMethods. I am trying to call the stored procedure from webMethods and I have done the following.

I have created a stored procedure using DB2 using the following command.
create procedure test_sp
(out sql_state1 char(5))
dynamic result sets 2
language sql
begin
declare sqlstate char(5);
declare rs1 cursor with return for
select TEST from TESTSP;
open rs1;
set sql_state1=sqlstate;

TESTSP – TABLE NAME
TEST – COLUMN IN THE TABLE of type VARCHAR

My entries for the same in adapter service in webMethods are as follows:

JDBCTYPE - VARCHAR
Return Field name - TEST

PARAM JDBC TYPE - VARCHAR
PARAM NAME - TEST
PARAM TYPE - OUT
EXPRESSION - ?

OUTPUT NAME - TEST
OUTPUT TYPE - java.lang.String

RESULTSET INDEX - 1
RESULTSET NAME - RS

Is this correct and Is there any other else, i need to specify ?

I get the following error for this when i run this ( I am running this through the TEST->RUN option ) .

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ‘Package name’: ‘adapterservice name’.
[ADA.1.316] Cannot execute the SQL statement “{? = call db name.DB2ADMIN. (?) }”. "
(07009/0) [wm-cjdbc33-0009][DB2 JDBC Driver]Invalid parameter binding(s)."
[wm-cjdbc33-0009][DB2 JDBC Driver]Invalid parameter binding(s).

Can you plz help me out ??

Thanks