1 10:16:43 SQL Prepare: ORACLE - select SQ_WZ_CGJH00_CGJHDH.NEXTVAL CGJHDH from dual 2 10:16:43 SQL Execute: ORACLE - select SQ_WZ_CGJH00_CGJHDH.NEXTVAL CGJHDH from dual 3 10:16:43 SQL Misc: ORACLE - Set rowset size 4 10:16:43 SQL Stmt: ORACLE - Fetch 5 10:16:43 SQL Stmt: ORACLE - EOF 6 10:16:43 SQL Data Out: ORACLE - Column = 1, Name = CGJHDH, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 36306.000000 7 10:16:43 SQL Stmt: ORACLE - Reset 8 10:16:43 SQL Stmt: ORACLE - Close 9 10:16:43 SQL Prepare: ORACLE - INSERT INTO WZ_CGJH00 (CGJHDH,CGJHRQ,CGJHSJ,CGJHR0,CGKSBH,JHKSBH,JHLB00,BZ0000) VALUES(:1,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS') ,1295,:2,:3,:4,:5) 10 10:16:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36306.000000 11 10:16:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 580.000000 12 10:16:43 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 552.000000 13 10:16:43 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 14 10:16:43 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 15 10:16:43 SQL Execute: ORACLE - INSERT INTO WZ_CGJH00 (CGJHDH,CGJHRQ,CGJHSJ,CGJHR0,CGKSBH,JHKSBH,JHLB00,BZ0000) VALUES(?,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS') ,1295,?,?,?,?) 16 10:16:43 SQL Data In: ORACLE - Rows affected = 1 17 10:16:43 SQL Stmt: ORACLE - Close 18 10:16:43 SQL Prepare: ORACLE - select count(1) Numcount from wz_cgjh00 where CGJHDH = 36306 19 10:16:43 SQL Execute: ORACLE - select count(1) Numcount from wz_cgjh00 where CGJHDH = 36306 20 10:16:43 SQL Misc: ORACLE - Set rowset size 21 10:16:43 SQL Stmt: ORACLE - Fetch 22 10:16:43 SQL Stmt: ORACLE - EOF 23 10:16:43 SQL Data Out: ORACLE - Column = 1, Name = NUMCOUNT, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 24 10:16:43 SQL Stmt: ORACLE - Reset 25 10:16:43 SQL Stmt: ORACLE - Close 26 10:16:43 SQL Stmt: ORACLE - Reset 27 10:16:43 SQL Stmt: ORACLE - Close 28 10:16:43 SQL Prepare: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='' 29 10:16:43 SQL Execute: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='' 30 10:16:44 SQL Misc: ORACLE - Set rowset size 31 10:16:44 SQL Stmt: ORACLE - Fetch 32 10:16:44 SQL Stmt: ORACLE - EOF 33 10:16:44 SQL Stmt: ORACLE - Reset 34 10:16:44 SQL Stmt: ORACLE - Close 35 10:16:44 SQL Prepare: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='武汉智迅创源' 36 10:16:44 SQL Execute: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='武汉智迅创源' 37 10:16:44 SQL Misc: ORACLE - Set rowset size 38 10:16:44 SQL Stmt: ORACLE - Fetch 39 10:16:44 SQL Stmt: ORACLE - EOF 40 10:16:44 SQL Data Out: ORACLE - Column = 1, Name = CJID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 40005.000000 41 10:16:44 SQL Prepare: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,:1, :2,:3,:4,:5,:6,:7 ,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21) 42 10:16:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36306.000000 43 10:16:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.590000 44 10:16:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8505.000000 45 10:16:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 一次性精密输液器 46 10:16:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 卫生材料 47 10:16:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = Weo-TX-32B-5.0 48 10:16:44 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 49 10:16:44 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 付 50 10:16:44 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1500.000000 51 10:16:44 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 52 10:16:44 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1083 53 10:16:44 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 54 10:16:44 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 55 10:16:44 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 56 10:16:44 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 40005 57 10:16:44 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 武汉智迅创源 58 10:16:44 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 10:16:44 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 60 10:16:44 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 10:16:44 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 10:16:44 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 63 10:16:44 SQL Execute: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,?, ?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 64 10:16:44 SQL Data In: ORACLE - Rows affected = 1 65 10:16:44 SQL Stmt: ORACLE - Close 66 10:16:44 SQL Stmt: ORACLE - Reset 67 10:16:44 SQL Stmt: ORACLE - Close 68 10:16:44 SQL Prepare: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='' 69 10:16:44 SQL Execute: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='' 70 10:16:44 SQL Misc: ORACLE - Set rowset size 71 10:16:44 SQL Stmt: ORACLE - Fetch 72 10:16:44 SQL Stmt: ORACLE - EOF 73 10:16:44 SQL Stmt: ORACLE - Reset 74 10:16:44 SQL Stmt: ORACLE - Close 75 10:16:44 SQL Prepare: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='武汉智迅创源' 76 10:16:44 SQL Execute: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='武汉智迅创源' 77 10:16:44 SQL Misc: ORACLE - Set rowset size 78 10:16:44 SQL Stmt: ORACLE - Fetch 79 10:16:44 SQL Stmt: ORACLE - EOF 80 10:16:44 SQL Data Out: ORACLE - Column = 1, Name = CJID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 40005.000000 81 10:16:44 SQL Prepare: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,:1, :2,:3,:4,:5,:6,:7 ,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21) 82 10:16:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36306.000000 83 10:16:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.590000 84 10:16:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8505.000000 85 10:16:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 一次性精密输液器 86 10:16:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 卫生材料 87 10:16:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = Weo-TX-32B-5.0 88 10:16:44 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 89 10:16:44 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 付 90 10:16:44 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1500.000000 91 10:16:44 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 10:16:44 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1083 93 10:16:44 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 94 10:16:44 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 95 10:16:44 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 96 10:16:44 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 40005 97 10:16:44 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 武汉智迅创源 98 10:16:44 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 99 10:16:44 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 100 10:16:44 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 101 10:16:44 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 102 10:16:44 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 103 10:16:44 SQL Execute: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,?, ?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 104 10:16:44 SQL Data In: ORACLE - Rows affected = 1 105 10:16:44 SQL Stmt: ORACLE - Close 106 10:16:44 SQL Stmt: ORACLE - Reset 107 10:16:44 SQL Stmt: ORACLE - Close 108 10:16:44 SQL Prepare: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='苏州新区明基高分子医疗器械有限公司' 109 10:16:44 SQL Execute: ORACLE - select GHDWID from VW_BM_WZGHDW where GHDWMC='苏州新区明基高分子医疗器械有限公司' 110 10:16:44 SQL Misc: ORACLE - Set rowset size 111 10:16:44 SQL Stmt: ORACLE - Fetch 112 10:16:44 SQL Stmt: ORACLE - EOF 113 10:16:44 SQL Data Out: ORACLE - Column = 1, Name = GHDWID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 40282.000000 114 10:16:44 SQL Stmt: ORACLE - Reset 115 10:16:44 SQL Stmt: ORACLE - Close 116 10:16:44 SQL Prepare: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='江苏' 117 10:16:44 SQL Execute: ORACLE - select CJID00 from VW_BM_WZSCCJ where SCCJZW='江苏' 118 10:16:44 SQL Misc: ORACLE - Set rowset size 119 10:16:44 SQL Stmt: ORACLE - Fetch 120 10:16:44 SQL Stmt: ORACLE - EOF 121 10:16:44 SQL Data Out: ORACLE - Column = 1, Name = CJID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 702.000000 122 10:16:44 SQL Prepare: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,:1, :2,:3,:4,:5,:6,:7 ,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21) 123 10:16:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 36306.000000 124 10:16:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.800000 125 10:16:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 112301.000000 126 10:16:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 护理包 127 10:16:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 卫生材料 128 10:16:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔型 129 10:16:44 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 10:16:44 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 套 131 10:16:44 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 750.000000 132 10:16:44 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 34, Scale = 0, Data = 苏州新区明基高分子医疗器械有限公司 133 10:16:44 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 134 10:16:44 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 135 10:16:44 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 250 136 10:16:44 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 137 10:16:44 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 702 138 10:16:44 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 江苏 139 10:16:44 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 40282 140 10:16:44 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 10:16:44 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 142 10:16:44 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 143 10:16:44 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 144 10:16:44 SQL Execute: ORACLE - INSERT INTO WZ_CGJHMX (CGMXID,CGJHDH,CGDJ00 ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,JHSL00,GYSMC0,ZBXH00,BZ0000,KCZSL0,ZBQNM0,SCCJID,SCCJZW,GHDWID,XZZD01,XZZD02,XZZD03,XZZD04) VALUES(SQ_WZ_CGJHMX_CGMXID.NEXTVAL,?, ?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 145 10:16:44 SQL Error: ORACLE - ORA-12899: 列 "SD_SB"."WZ_CGJHMX"."GYSMC0" 的值太大 (实际值: 34, 最大值: 30) 146 10:16:44 SQL Error: ORACLE - Unmapped SQL Error Code: 12899 147 10:16:44 SQL Stmt: ORACLE - Reset 148 10:16:44 SQL Data In: ORACLE - Rows affected = 0 149 10:16:44 SQL Stmt: ORACLE - Close 150 10:16:44 SQL Prepare: ORACLE - Rollback 151 10:16:44 SQL Execute: ORACLE - Rollback 152 10:16:44 SQL Data In: ORACLE - Rows affected = 0 153 10:16:44 SQL Stmt: ORACLE - Close 154 10:16:44 SQL Transact: ORACLE - XACT Abort 155 10:16:44 SQL Prepare: ORACLE - ROLLBACK WORK 156 10:16:44 SQL Execute: ORACLE - ROLLBACK WORK 157 10:16:44 SQL Stmt: ORACLE - Close