Getting result from stored procedure

params.add(new SqlParameter("p_work_date", Types.DATE));

params.add(new SqlOutParameter("p_out_load", OracleTypes.CURSOR));

Map results = jdbcTemplate.call(new CallableStatementCreator() {

public CallableStatement createCallableStatement(Connection con)

throws SQLException {

CallableStatement cs =

con.prepareCall(

"{call PKG_BKP_LOAD.SP_LOAD_STAT(?,?)}");

cs.setDate(1, sqlDate);

cs.registerOutParameter(2, OracleTypes.CURSOR);

return cs;

}

}, params);

*****

now how shoudl i get the out parameters?

i m quite new to the springs

junkbustera at 2007-7-12 9:40:10 >

> Please post your

> [url=http://forum.java.sun.com/help.jspa?sec=formattin

> g ]formatted[/url] code demonstrating what you

> have tried along with the exact error message and

> resulting stack trace.

Obviously embedding the link confused him, perhaps this would have been clearer...

[url=http://forum.java.sun.com/help.jspa?sec=formatting]http://forum.java.sun.com/help.jspa?sec=formatting[/url]

macrules2a at 2007-7-12 9:40:10 >