SP output params - multiple

Hi,

I am calling a stored procedure, which has 2 output params.

How do I do this from JDBC?

My SP has 2 input and 2 output params. If i do this -

cstmt = con.prepareCall("{?=call " + prcTest + "(?, ?)}");

//setting input params

cstmt.setString(3,"abc");

cstmt.setString(4,"def");

cstmt.registerOutParameter(1, Types.INT);

cstmt.registerOutParameter(2, Types.CHAR);

cstmt.executeUpdate();

result = cstmt.getInt(1);

errorList = cstmt.getString(2);

This doesnt work. Please help!

Thanks.

[575 byte] By [arbitarya] at [2007-10-2 7:06:07]