Stored Procedure Parameters Problem

[samhuang]

Hi,
I run stored procedures defined in external sql files. The stored procedures are written in the form of
call ABCD.proc(?, ?)

Since the types and the numbers of parameters are defined in runtime, so I cannot figure out it in my code use declareParameter(name, type).

I want to use the style of JdbcTemplate.queryForList(string, Object[]) instead of execute(Map), it looks like
execute(string, Object[]). Any one knows how to do this? Thx!

[julien.dubois]

You should have a look at the doc here :

http://static.springframework.org/sp...toredProcedure

[kasim]

private static void byStoredProcedure(JdbcTemplate jt2) {
        CallableStatementCallback cb = new CallableStatementCallback(){
            public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
                cs.execute();
                return null;
            }
            
        };
        
        jt2.execute("{cdo_sp(?,?)}", cb);
        
    } 

here i need to set the parameter, how can set the parameter?

[karldmoore]

This appears to be a duplicate................
http://forum.springframework.org/showthread.php?t=40890