实现方案一:
INSERT INTO WF_TASKTEMP_DEALSTAFF (DEAL_ID, TEMP_ID, STAFF_ID,DEAL_TYPE, STATUS)
SELECT WF_TASKTEMP_DEALSTAFF$SEQ.NEXTVAL,a.* FROM (
SELECT
#{item.tempId,jdbcType=VARCHAR},
#{item.staffId,jdbcType=VARCHAR},
#{item.dealType,jdbcType=VARCHAR},
#{item.status,jdbcType=CHAR}
FROM dual
) a
实现方案二:
begin
insert into WF_TASKTEMP_DEALSTAFF
(
DEAL_ID, TEMP_ID, STAFF_ID,DEAL_TYPE, STATUS
)
values(WF_TASKTEMP_DEALSTAFF$SEQ.nextval,
#{item.tempId,jdbcType=VARCHAR},
#{item.staffId,jdbcType=VARCHAR},
#{item.dealType,jdbcType=VARCHAR},
#{item.status,jdbcType=CHAR}
);
end;