Call stored procedure with Spring

[Bruce Jin]

I have a stored procedure with 1 parameter (INOUT DECIMAL).
My class extends Spring framework StoredProcedure class. It errors at line:

Map outParams = execute(inParams);

java.sql.SQLException: The number of parameter values set or registered does not match the number of parameters.

The code is as follows:

    
public class TestStoredProcedure extends StoredProcedure {
 
public TestStoredProcedure(JdbcTemplate tpl, String proc) {
        super(tpl, proc);
 
        declareParameter(new SqlParameter("P1", Types.DECIMAL));
        compile();
    }
 
    public String execute( ) {
        Map inParams = new HashMap(1);
        inParams.put("P1", new BigDecimal(123456));  
        execute(inParams);
     
        Map outParams = execute(inParams);
        if (outParams.size() > 0) {
            return outParams.get("P1").toString();
        } else {
            return null;
        } 
    }
    
public static void main(String[] args) {
String procName  = "ORTNSYSDT";
JdbcTemplate tpl = SpringStore.getJdbcTpl(1);
TestStoredProcedure test = new TestStoredProcedure(tpl, procName); 
test.execute( );
System.out.println("end.");
}
 
}

[Bruce Jin]

Found out it must be:

declareParameter(new SqlOutParameter("P1", Types.DECIMAL));

instead of:

declareParameter(new SqlParameter("P1", Types.DECIMAL));

[Darvesh Niz]

(Blatant advertisin not allowed in this forum, and please don't resurrect months old threads. - Mark Spritzler)