<update id="batchUpdate">
<foreach collection="pos" item="po" separator=";" index="index" open="begin" close=";end;">
UPDATE
ITEM.CUST_DIST_PRICE
SET
FXPF_PRICE = #{po.fxpfPrice},
NEW_FXPF_PRICE = #{po.newFxpfPrice},
OLD_FXPF_PRICE = #{po.oldFxpfPrice},
ERROR_REASON = #{po.errorReason},
CREATION_DATE =
to_date(#{po.creationDateStr},'YYYY-MM-DD hh24:mi:ss'),
CREATION_BY = #{po.creationBy},
LAST_MODIFIED_DATE =
to_date(#{po.lastModifiedDateStr},'YYYY-MM-DD hh24:mi:ss'),
LAST_MODIFIED_BY = #{po.lastModifiedBy},
IS_DELETE = #{po.deleted}
where
CUST_DIST_PRICE_ID = #{po.id}
</foreach>
</update>