Map map = new HashMap();
map.put("pathdylist", pathdylist);
map.put("FORGID", forgid);
getPathDyDAOImpl().deleteCpinf(map);
<delete id="deleteCpinf" parameterClass="java.util.Map">
begin
delete cp_base_pgdy t where t.pathid in (
select t.pathid from cp_base_pathdy t
where t.pathcode in
<iterate property="pathdylist" conjunction="," open="(" close=")">
#pathdylist[].PATHCODE#
</iterate>
and t.forgid = #FORGID#
);
delete cp_base_lcfa t where t.pathid in (
select t.pathid from cp_base_pathdy t
where t.pathcode in
<iterate property="pathdylist" conjunction="," open="(" close=")">
#pathdylist[].PATHCODE#
</iterate>
and t.forgid = #FORGID#
);
delete cp_base_lcdy t where t.pathid in (
select t.pathid from cp_base_pathdy t
where t.pathcode in
<iterate property="pathdylist" conjunction="," open="(" close=")">
#pathdylist[].PATHCODE#
</iterate>
and t.forgid = #FORGID#
);
delete cp_base_pathdy t where t.pathid in (
select t.pathid from cp_base_pathdy t
where t.pathcode in
<iterate property="pathdylist" conjunction="," open="(" close=")">
#pathdylist[].PATHCODE#
</iterate>
and t.forgid = #FORGID#
);
end;
</delete>