public class ExecuteProceduresDaoImpl extends JdbcDaoSupport implements ExecuteProceduresDao {
public Object Call_prLS_OrderByMemberOrNotMember(final String[] parm) {
private static String PROC_TEST = "{call PKG_TEST.PRO_TEST(?,?,?)}";
public Boolean cal(final Date date, final String createdCode) throws SQLException {
return (Boolean) getJdbcTemplate().execute(PROC_TEST, new CallableStatementCallback() {
public Object doInCallableStatement(CallableStatement stmt)
throws SQLException, DataAccessException {
stmt.registerOutParameter(1, OracleTypes.VARCHAR);
stmt.setDate(2, new java.sql.Date(date.getTime()));
stmt.setString(3, createdCode);
stmt.executeQuery();
String result = stmt.getString(1);
if (result != null && result.equals("1")) {
return true;
}
return false;
}
});
}
----储存过程
PROCEDURE PRO_TEST(P_RETURN_MSG OUT VARCHAR2,
P_DT IN DATE,
P_CODE IN VARCHAR2) AS