hibernate调用存储过程

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;
/