hi,
will this help?

here's SP
Code:
public class SpGetSqlParams extends StoredProcedure {

    Map  results = new HashMap();

    SpGetSqlParams(JdbcTemplate template,
                  String name) {
        super(template, name);

        declareParameter(new SqlReturnResultSet("rs", new RowMapper() {
            public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
                Map map = new HashMap();
                map.put(SPConstants.PARM_ID, rs.getString(1));
                map.put(SPConstants.PARM_NAM, rs.getObject(2));
                map.put(SPConstants.PARM_VAL, rs.getObject(3));
                map.put(SPConstants.DAT_TYP, rs.getObject(4));
                return map;
            }}));
        declareParameter(new SqlParameter(SPConstants.FLOW_TASK_ID,
                                            Types.INTEGER));

        
        compile();
     }

    public Map execute(Map inParams) {
        // populate inParams
        return super.execute(inParams);
    }

}
and here's code that is calling it

Code:
StoredProcedure sp = spFactory.getStoredProcedure("spGetSqlParms");
Map map = new HashMap();
map.put(SPConstants.FLOW_TASK_ID, 1);
Map results = sp.execute(map);
System.err.println("RETURNED MAP IS:" + results);
there's an IN parameter as well as a result set returned...


hth
marco