请问如何用java调用INFORMIX的存储过程,并且返回参数
代码如下:
create procedure p_drect_combin(begin_date varchar(10),end_date varchar(10),out resultx int)
returning int ;
define result varchar(1);
define zl_reflag varchar(2);
define act_date_check varchar(10);
let result = '0';
let zl_reflag = '-1';
let result1 =0;
return result1;
end procedure;
java调用部分
CallableStatement cstmt = null;
// com.informix.jdbc.IfmxCallableStatement
//java.sql.CallableStatement
try {
con = db.getConnection();
// cstmt = (IfmxCallableStatement)con.prepareCall("{call p_drect_combin(?,?,?)}");
cstmt = con.prepareCall("{call p_drect_combin(?,?,?)}");
cstmt.setString(1,"2006-06-02");
cstmt.setString(2, "2006-06-02");
cstmt.registerOutParameter(3,Types.INTEGER);
// cstmt.registerOutParameter(0,com.informix.lang.Types2.VARCHAR);
cstmt.execute();
提示错误:输入值号与问题标志号不匹配