Oracle insert报填写变量variables

今天不小心在oracle里面删了一条数据，再insert时报错
Oracle数据插入报错填写变量variables

第一感觉是不是哪有触发器，找了一下，发现不是。仔细看sql语句，值里面带有& 这是个特殊符号呀，肯定有问题，把&批量替换成 '||'&'||' 顺利解决

insert into ci_order (ID_OR, ID_GRP, ID_ORG, ID_PAT, ID_EN, ID_ENTP, CODE_ENTP, ID_SRVTP, SD_SRVTP, ID_SRV_PKG, FG_LONG, CODE_OR, CONTENT_OR, DES_OR, ID_FREQ, ORDERS, FG_BOIL, ORDERS_BOIL, ID_ROUTE, ID_ROUTEDES, ID_BOIL, ID_BOILDES, DAYS_OR, ID_SU_OR, SD_SU_OR, ID_SU_MP, SD_SU_MP, ID_SU_BL, SD_SU_BL, ID_ORG_OR, ID_DEP_OR, ID_WG_OR, ID_EMP_OR, DT_ENTRY, FG_SIGN, ID_EMP_SIGN, ID_DEP_SIGN, DT_SIGN, DT_EFFE, DT_INVALID, FG_CHK, ID_EMP_CHK, ID_DEP_CHK, DT_CHK, FG_STOP, ID_EMP_STOP, ID_DEP_STOP, DT_STOP, FG_CHK_STOP, ID_EMP_CHK_STOP, ID_DEP_CHK_STOP, DT_CHK_STOP, FG_CANC, ID_EMP_CANC, ID_DEP_CANC, DT_CANC, FG_CHK_CANC, ID_EMP_CHK_CANC, ID_DEP_CHK_CANC, DT_CHK_CANC, FG_PMOR, DES_PMOR, FG_ACTIVE_PM, ID_RELTP, SD_RELTP, ID_OR_REL, FG_BB, NO_BB, FG_CTLCP, FG_MR, FG_SKINTEST, FG_MP_IN, TIMES_MP_IN, FG_MP_BED, NOTE_OR, CREATEDBY, CREATEDTIME, MODIFIEDBY, MODIFIEDTIME, EU_VERIFY_PHARM, DES_VERIFY_PHARM, ID_EXCEP_LEVEL_PHARM, SD_EXCEP_LEVEL_PHARM, DES_VERIFY_SYS, ID_EXCEP_LEVEL_SYS, SD_EXCEP_LEVEL_SYS, ID_EMP_VERIFY_PHARM, DT_VERIFY_PHARM, DES_BK_PHARM, DT_BK_PHARM, ID_EMP_BK_PHARM, DS, SV, ID_ECEP_LEVEL_SYS, ID_ECEP_LEVEL_PHARM, DT_END, NAME_OR, ID_SRVCA, FG_PKG, QUAN_FIRDAY_MP, FG_OR_FORM, ID_SKINTEST_SKIP_REASON, SD_SKINTEST_SKIP_REASON, ID_SRV, FG_SET, ID_SRV_SET, TIMES_FIRDAY_MP, FG_PRES_OUTP, FUNCCLASSSTR, ID_SRVOF, APPLYNO, DT_LAST_BL, FG_URGENT, ID_ORPLTP, TIMES_CUR, ID_ORRSTTP, SD_ORRSTTP, ID_DEP_MP, DT_LAST_MP, ID_UNIT_MED, QUAN_MEDU, INNERCODE_SRVCA, FG_UNCANCELABLE, EU_HPINDICJUDGE, EU_UNCPORJUDGE, REASON_UNCPORUSE, PURPOSE_OR, FG_FLUSH2MR, FG_FEERTNABLE, FG_QUICKWFLOW, EU_ORSRCMDTP, ID_ORSRC_MAIN, ID_ORSRC_SUB, ID_ORSRC_SUBSUB, BHPJUDGERST, DES_BHPJUDGERST, FG_VIP, FG_PREPAY, FG_ORHP, EU_FEEREVERSETP, ID_EXCESSIVE_REASON, SD_EXCESSIVE_REASON, FG_PRN, ID_EMP_SECOND_CHK, SORTNO, DEF1, DEF2, DEF3, DEF4, DEF5, EXTENDEDINFO, ISMULEXEC, ISMULDOSE, ISHOSPITALHERBPRES, ID_RESEARCHPROJECT, CODE_RESEARCHPROJECT, FG_RESEARCH, FG_HOSPITAL_HERBPRES, SD_TOTALOPENMODE, FG_SPEC_ANTI_APPROVE, SD_SPEC_ANTI_APPROVE, ERROR_DES, EU_REFUSECHECKTP, FG_REFUSECHECK, ID_EMP_REFUSECHECK, DT_REFUSECHECK, FG_PAY_UNIT, ID_DEP_NUR_OR, FG_RECHECK, ID_EMP_RECHECK, DT_RECHECK, ERROR_LEVEL, ID_ORSRCFUN, SD_ORSRCFUN, FG_INFECT_DEP_CONS, FG_DELIVERYROOM_USE, ID_DIDEF, NAME_DIDEF, MORE_MONEY_REASON, ID_DRIPSPEED, ID_MESSAGE, ID_DRUGDELIVERYMETHOD, SD_DRUGDELIVERYMETHOD, NAME_DRUGDELIVERYMETHOD, FG_WHOLEPACK)

values ('1001Z8100000001N16B7', '0001HH100000000001OE', '0001Z8100000000006BQ', '1001Z8100000001DAJF4', '1001Z8100000001N0UK9', '@@@@AA10000000004O80', '00', '@@@@W11000000003UM0S', '010103', '~', 'Y', '01292681', '0102||0.9%氯化钠注射液[100毫升/袋] 西药房'||'&'||'100'||'&'||'毫升'||'&'||'3.19元 1袋.^注射用美洛西林钠舒巴坦钠[0.625克/支] 西药房'||'&'||'1'||'&'||'支'||'&'||'14.74元 1支|静脉滴注，2/日(8am-4pm)，抗生素治疗使用', null, '1001Z81000000012FZR6', null, 'N', null, '1001Z81000000012O8D5', null, '~', '~', 1, '@@@@AA1000000001SG7U', '10', '@@@@AA1000000004KRCB', '1', '@@@@AA10000000026639', '1', '0001Z8100000000006BQ', '1001Z8100000001DXTHI', '~', '1001Z810000000178FRR', '2019-12-21 17:24:43', 'Y', '1001Z810000000178FRR', '1001Z8100000001DXTHI', '2019-12-21 17:24:46', '2019-12-21 08:00:00', '2019-12-22 08:00:00', 'N', '~', '~', null, 'Y', '1001Z810000000178FRR', '1001Z8100000001DXTHI', '2019-12-21 17:24:43', 'N', '~', null, null, 'N', '~', '~', null, 'N', '~', '~', null, 'N', null, 'N', '~', null, '~', 'N', null, 'N', 'N', 'N', 'Y', 2, 'N', null, '0001Z8100000000YUM8U', '2019-12-21 17:24:43', '0001Z810000000082YFN', '2019-12-21 17:28:54', 1, null, '~', null, null, '~', null, '1001Z810000000135JNN', '2019-12-21 17:28:54', null, null, '~', 0, '2019-12-21 17:28:54', '~', '~', '2019-12-22 08:00:00', '0.9%氯化钠注射液,注射用美洛西林钠舒巴坦钠', '1001Z810000000129SQL', 'N', null, 'Y', '~', null, '1001Z81000000012AM4G', 'N', null, null, 'N', 'e0RsbDooaWloLmNpLm9yZC5kbGwpLENsYXNzcGF0aF9kbGw6KGlpaC5jaS5vcmQub2Vwc3RhdGlvbi5lbXMuZHJ1Z3MuRW1zRHJ1Z3NEcml2ZXIpLEphcjooaWloLmNpLm9yZC5qYXIpLENsYXNzcGF0aF9qYXI6KGlpaC5jaS5vcmQucy5lbXMub3AuZW1zLmRydWdzLkVtc0RydWdzRHJpdmVyKSxFbXN0eXBlOigxKSxTdGF0dXM6KDIpLERpcnR5OihmYWxzZSl9', '1001Z81000000012CHK2', null, '2019-12-22 08:00:01', 'N', '@@@@Z8100000000LT26W', 2, '~', null, '1001Z81000000012J71R', '2019-12-21 16:00:00', '@@@@Z7100000000NY5UI', null, 'XLVP', 'Y', 0, 0, null, null, 'Y', 'N', 'N', '01', null, null, null, '099', null, 'N', 'N', 'N', null, null, null, 'Y', '~', 21, null, null, null, null, null, null, 'N', 'N', 'N', '~', null, 'N', 'N', '0', 'N', null, null, null, 'N', '~', null, 'N', '~', 'N', '~', null, 'A', '~', null, 'N', 'N', '0001Z81000000005S6VD', '急性扁桃体炎', null, '~', '~', '~', null, null, 'N'); Oracle insert报填写变量variables:http://www.751com.cn/fanwen/lunwen_43879.html