stored procedure: Parameter index out of range

[Edward Chen]

I call stored proc, but I got a parameter index error. Anybody has some ideas ?

Thanks.

Vector params = new Vector();

params.add(new SqlOutParameter("statusCode", Types.INTEGER));
params.add(new SqlParameter("id", Types.INTEGER));
params.add(new SqlOutParameter("num", Types.INTEGER));
params.add(new SqlParameter("prin", Types.DOUBLE));
params.add(new SqlParameter("notional", Types.CHAR));
params.add(new SqlParameter("src", Types.VARCHAR));
params.add(new SqlParameter("pgm", Types.VARCHAR));

try {
Map retMap = jt.call(new CallableStatementCreator() {
 
public CallableStatement createCallableStatement(Connection con)
throws SQLException {
CallableStatement cs = con.prepareCall("{ ? = call "
+ "upd (?,?,?,?,?,?)}");
 
cs.registerOutParameter(1, java.sql.Types.INTEGER);
cs.setInt(2, id.intValue());
cs.setInt(3, compNumber.intValue());
cs.setDouble(4, faceAmount.doubleValue());
cs.setString(5, nolag);
cs.setString(6, ContextHelper.getUserContext().getUserId());
cs.setString(7, "M");
return cs;
}
}, params);
 

stored procedure is:

create procedure upd
@idint,
@numint,
@prinfloat,
@notionalchar(1),
@srcdata_src_code_dtp,
@pgmpgm_src_code_dtp
as
begin
declare @errmsgvarchar(255)
 
......
return 0
 
end
 

Why I got error message "Caused by: java.sql.SQLException: JZ0SB: Parameter index out of range: 1."

Sybase says that
//////////
Parameter index out of range: _____.

Description: You have attempted to get, set, or register a parameter that goes beyond the maximum number of parameters.
Action: Check the number of parameters in your query.
///////////////

But you see, my parameters are right. Why?