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!