this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
// CallableStatement cs=session.connection().prepareCall("{call proc_delBzwbZXByPrjcode(?)}");
//cs.setString(1, prjcode);
//cs.execute();
SQLQuery sqlQuery = session.createSQLQuery("{call proc_delBzwbZXByPrjcode(?)}");
sqlQuery.setString(0, prjcode);
sqlQuery.executeUpdate();
return null;
}
});
存储过程Oracle
CREATE OR REPLACE PROCEDURE ZSHQ.proc_delBzwbZXByPrjcode(
pjcode IN VARCHAR2
) AS
BEGIN
--专项标准文本--
delete from Sb_Bzwb_Zx where PRJCODE = pjcode;
delete from Sb_Bzwb_Zx_PrjInfo where PRJCODE = pjcode;
END proc_delBzwbZXByPrjcode;
/