<insert id="insertOFACNameDetails" useGeneratedKeys="false">
        INSERT INTO ${sdnTableName} (ENT_NUM, SDN_NAME, SDN_TYPE, PROGRAM, TITLE, CALL_SIGN, VESS_TYPE, TONNAGE, GRT, VESS_FLAG, VESS_OWNER, REMARKS, CREATED_DATE) VALUES
        <foreach collection="ofacSDNDetails" item="sdnDetail"
            separator=",">
            (${sdnDetail.entNum},${sdnDetail.sdnName},${sdnDetail.sdnType},${sdnDetail.program},${sdnDetail.title},${sdnDetail.callSign},
            ${sdnDetail.vessType},${sdnDetail.tonnage},${sdnDetail.grt},${sdnDetail.vessFlag},${sdnDetail.vessOwner},${sdnDetail.remarks},
            sysdate)
        </foreach>
</insert>

INSERT INTO LAND.OFAC_SDN (ENT_NUM, SDN_NAME, SDN_TYPE, PROGRAM, TITLE, CALL_SIGN, VESS_TYPE, TONNAGE, GRT, VESS_FLAG, VESS_OWNER, REMARKS, CREATED_DATE) VALUES         (36,'AEROCARIBBEAN AIRLINES','0','CUBA','0','0',    '0','0','0','0','0','0',    sysdate)  ,     (173,'ANGLO CARIBBEAN CO LTD','0','CUBA','0','0',    '0','0','0','0','0','0',    sysdate)