首次新增一行数据就无法写入数据
merge into t_mq_bu_sap_mes_firstcar_sub t1
using (select :ZWYBS2 as ZWYBS
from dual) t2
on (t1.ZWYBS = t2.ZWYBS)
when not matched then
insert
(ZID,ZWYBS,IDNRK,MENGE,AUSCH,POTX1,POXT2,DEP_LINE,SORTF,ZCZZT,ZYL01,ZYL02,ZYL03,ZYL04,ZYL05,ZYL06)
values (:ZID,:ZWYBS,:IDNRK,:MENGE,:AUSCH,:POTX1,:POXT2,:DEP_LINE,:SORTF,:ZCZZT,:ZYL01,:ZYL02,:ZYL03,:ZYL04,:ZYL05,:ZYL06)
数据表无法写入数据,也没有抛出异常报错
想了解merge into 的写入规则
实现写入数据
没人会吗?