ibatis调用存储过程

<!-- 删除bl的有效库的branch信息 -->
	<!-- 	CREATE PROCEDURE DELETEBBRANCHANDOTHER
	(IN branchId VARCHAR(32))
	BEGIN
	        DELETE FROM TBZBBIO_EQUIP a WHERE a.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBBIOABILITY_LEVEL b WHERE b.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBBIO_ACCORD c WHERE c.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBBIO_LEVEL d WHERE d.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBPERSON_RELATE e WHERE e.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBPERSONTYPE f WHERE f.BRANCH_ID in ( branchId );
		    DELETE FROM TBZBBRANCH g WHERE g.BRANCH_ID in (branchId );
	END -->
	
	<procedure id="deleteBlBbranchAndOther"  parameterClass="java.util.Map"> 
		<![CDATA[
					{call DELETEBBRANCHANDOTHER(#value:VARCHAR#)} 
		]]>
	</procedure>

ibatis调用存储过程

Map map=new HashMap();
			map.put("branchId", sourceid);
			if(labType.equals(CnasConstants.LAB_TYPE_BL)){
				bbranchDAO.execute("deleteBlBbranchAndOther",map);
			}