ibatis 配置 merge into 出错
<update id="updatedepReceiverList" parameterClass="com.common.dto.NlDepartmentSpecialPositionVO" >
<![CDATA[
MERGE INTO NL_DEPARTMENT_SPECIAL_POSITION L
USING (SELECT 1 FROM DUAL) N
ON (L.DEPARTMENT_CODE = #department_code# AND L.SPECIAL_TYPE = #special_type#)
WHEN MATCHED THEN
UPDATE SET L.USER_CODE = #user_code#
WHEN NOT MATCHED THEN
INSERT
(CREATED_BY,
CREATED_DATE,
UPDATED_BY,
UPDATED_DATE,
DEPARTMENT_CODE,
SPECIAL_TYPE,
USER_CODE)
VALUES
(#createdBy#, SYSDATE, #updatedBy#, SYSDATE, #department_code#, #special_type#, #user_code#)
]]>
</update>
如上,这个语句总是执行不过..搞了一天了,哪位大虾帮下忙呀~