mybatis를 사용하면서 xml에 sql문을 입력하게 되는데 하기와 같은 에러가 발생
쿼리문 : DELETE
FROM CAMPAIGN_CUSTOMER_INFO
WHERE REG_ID = #{userId}
AND CAMPAIGN_ID = 0
AND GROUP_SEQUENCE < #{groupSequence}
에러 내용 : The content of elements must consist of well-formed character data or markup.
해결방안 :
<delete id="deleteCampaignCustomerGr" parameterType="map">
<![CDATA[
DELETE
FROM CAMPAIGN_CUSTOMER_INFO
WHERE REG_ID = #{userId}
AND CAMPAIGN_ID = 0
AND GROUP_SEQUENCE < #{groupSequence}
]]>
</delete>