源自: insert into tp.out_appy_d (trt_dcla_detl_sn, poolarea, grp_type, org_id, org_cat, mdtrt_type, admdvs, addr, med_pool_type, begndate, enddate, out_fixmedins_code, dise_code, memo, tel, opt_time, dcla_souc, opter, dept_name, medrcdno, crter, crte_optins, coner_name,lt_flag, optins, fil_reg_stas, out_onln_flag, no_refl_trt, chk_flag , psn_no , rid , crte_time , updt_time ) values (:trt_dcla_detl_sn, :poolarea, :grp_type, :org_id, :org_cat, :mdtrt_type, :admdvs, :addr, :med_pool_type, :begndate, :enddate, :out_fixmedins_code, :dise_code, :memo, :tel, sysdate, :dcla_souc, :opter, :dept_name, :medrcdno, :crter, :crte_optins, :coner_name, :lt_flag, optins, :fil_reg_stas, :out_onln_flag, :no_refl_trt, :chk_flag , :triid__ , :rid__ , :crte_time__ , :updt_time__ );
参数:{updt_time__=2022-04-21 08:30:02.0, medrcdno=null, out_fixmedins_code=null, mdtrt_type="10", poolarea="377724", out_onln_flag="1", memo=null, admdvs="110000", org_cat=null, med_pool_type=null, begndate=2022-04-21 00:00:00.0, fil_reg_stas="1", dise_code="C80.000", tel="13506490000", rid__="370700202204210829013789424300", addr=null, crte_optins="377724", no_refl_trt=null, trt_dcla_detl_sn="37070000000078920864", dept_name=null, opter="37072419770400000000", dcla_souc="02", triid__="08370724200201306110", enddate=2022-04-28 00:00:00.0, org_id=null, crte_time__=2022-04-21 08:30:02.0, chk_flag=null, crter="37072419770407470000", coner_name=null, grp_type="B", lt_flag=null}
排查好长时间没看出问题在哪里?
出现的原因是由于,在插入字符或字符串型字段时。如果插入的数据是纯数字,则不会有错误;但是如果出现字符,就会报ORA-00984列在此处不允许异常。
grp_type,dise_code的类型是什么,最好把表结构贴出看来