1 16:05:34 SQL Stmt: ORACLE - Reset 2 16:05:34 SQL Stmt: ORACLE - Close 3 16:05:34 SQL Prepare: ORACLE - Select SYSDATE from Dual 4 16:05:34 SQL Execute: ORACLE - Select SYSDATE from Dual 5 16:05:34 SQL Misc: ORACLE - Set rowset size 6 16:05:34 SQL Stmt: ORACLE - Fetch 7 16:05:34 SQL Stmt: ORACLE - EOF 8 16:05:34 SQL Data Out: ORACLE - Column = 1, Name = SYSDATE, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/20/2012 16:5:34:0 9 16:05:34 SQL Stmt: ORACLE - Reset 10 16:05:34 SQL Stmt: ORACLE - Close 11 16:05:34 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 12 16:05:34 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 13 16:05:34 SQL Misc: ORACLE - Set rowset size 14 16:05:34 SQL Stmt: ORACLE - Fetch 15 16:05:34 SQL Stmt: ORACLE - EOF 16 16:05:34 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 49 17 16:05:34 SQL Stmt: ORACLE - Reset 18 16:05:34 SQL Stmt: ORACLE - Close 19 16:05:34 SQL Prepare: ORACLE - update XT_XTCS00 set VALUE0='55' where NAME00='IC_BBH' 20 16:05:34 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='55' where NAME00='IC_BBH' 21 16:05:34 SQL Data In: ORACLE - Rows affected = 1 22 16:05:34 SQL Stmt: ORACLE - Close 23 16:05:34 SQL Prepare: ORACLE - Commit 24 16:05:34 SQL Execute: ORACLE - Commit 25 16:05:34 SQL Data In: ORACLE - Rows affected = 0 26 16:05:34 SQL Stmt: ORACLE - Close 27 16:05:34 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 28 16:05:34 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 29 16:05:34 SQL Misc: ORACLE - Set rowset size 30 16:05:34 SQL Stmt: ORACLE - Fetch 31 16:05:34 SQL Stmt: ORACLE - EOF 32 16:05:34 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = SLE4442 33 16:05:34 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 34 16:05:34 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 35 16:05:34 SQL Stmt: ORACLE - Reset 36 16:05:34 SQL Stmt: ORACLE - Close 37 16:05:35 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 38 16:05:35 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 39 16:05:35 SQL Misc: ORACLE - Set rowset size 40 16:05:35 SQL Stmt: ORACLE - Fetch 41 16:05:35 SQL Stmt: ORACLE - EOF 42 16:05:35 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-MMRK 43 16:05:35 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 44 16:05:35 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = MMRK 45 16:05:35 SQL Stmt: ORACLE - Reset 46 16:05:35 SQL Stmt: ORACLE - Close 47 16:05:35 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 48 16:05:35 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 49 16:05:35 SQL Misc: ORACLE - Set rowset size 50 16:05:35 SQL Stmt: ORACLE - Fetch 51 16:05:35 SQL Stmt: ORACLE - EOF 52 16:05:35 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-FJYB 53 16:05:35 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 54 16:05:35 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = FZYB 55 16:05:35 SQL Stmt: ORACLE - Reset 56 16:05:35 SQL Stmt: ORACLE - Close 57 16:05:35 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 58 16:05:35 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 59 16:05:35 SQL Misc: ORACLE - Set rowset size 60 16:05:35 SQL Stmt: ORACLE - Fetch 61 16:05:35 SQL Stmt: ORACLE - EOF 62 16:05:35 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-FZYB 63 16:05:35 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 64 16:05:35 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = FZYB 65 16:05:35 SQL Stmt: ORACLE - Reset 66 16:05:35 SQL Stmt: ORACLE - Close 67 16:05:35 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 68 16:05:35 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 69 16:05:35 SQL Misc: ORACLE - Set rowset size 70 16:05:35 SQL Stmt: ORACLE - Fetch 71 16:05:35 SQL Stmt: ORACLE - EOF 72 16:05:35 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = YB-SBK 73 16:05:35 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 74 16:05:35 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = FZYB 75 16:05:35 SQL Stmt: ORACLE - Reset 76 16:05:35 SQL Stmt: ORACLE - Close 77 16:05:36 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK52611386' and ICKNBH = 'FZYBK52611386' 78 16:05:36 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK52611386' and ICKNBH = 'FZYBK52611386' 79 16:05:36 SQL Misc: ORACLE - Set rowset size 80 16:05:36 SQL Stmt: ORACLE - Fetch 81 16:05:36 SQL Stmt: ORACLE - EOF 82 16:05:36 SQL Data Out: ORACLE - Column = 1, Name = ICKH00, Type = fldZSTRING, Precision = 230, Scale = 0, Data = FZYBK52611386 83 16:05:36 SQL Data Out: ORACLE - Column = 2, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 84 16:05:36 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 99574.000000 85 16:05:36 SQL Data Out: ORACLE - Column = 4, Name = KMH000, Type = fldZSTRING, Precision = 230, Scale = 0, Data = FZYBK52611386 86 16:05:36 SQL Data Out: ORACLE - Column = 5, Name = ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 87 16:05:36 SQL Stmt: ORACLE - Reset 88 16:05:36 SQL Stmt: ORACLE - Close 89 16:05:36 SQL Prepare: ORACLE - select X.XM0000,X.XB0000,X.NL0000,X.YBMC00,X.LASTGH,X.BRBLH0,X.ZYE000 FROM VW_YF_BRJBXX_MZ X WHERE BRID00=:1 90 16:05:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 99574.000000 91 16:05:36 SQL Execute: ORACLE - select X.XM0000,X.XB0000,X.NL0000,X.YBMC00,X.LASTGH,X.BRBLH0,X.ZYE000 FROM VW_YF_BRJBXX_MZ X WHERE BRID00=? 92 16:05:36 SQL Blob IO: ORACLE - Return blob data 93 16:05:36 SQL Stmt: ORACLE - Fetch 94 16:05:36 SQL Data Out: ORACLE - Column = 1, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 洪光明 95 16:05:36 SQL Data Out: ORACLE - Column = 2, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 96 16:05:36 SQL Data Out: ORACLE - Column = 4, Name = YBMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 省医保中心 97 16:05:36 SQL Data Out: ORACLE - Column = 5, Name = LASTGH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4549889.000000 98 16:05:36 SQL Data Out: ORACLE - Column = 6, Name = BRBLH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = K52611386 99 16:05:36 SQL Data Out: ORACLE - Column = 7, Name = ZYE000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.430000 100 16:05:36 SQL Prepare: ORACLE - SELECT DTGHCS,GHKSMC FROM VW_YF_GHXX00 WHERE GHID00=:1 101 16:05:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4549889.000000 102 16:05:36 SQL Execute: ORACLE - SELECT DTGHCS,GHKSMC FROM VW_YF_GHXX00 WHERE GHID00=? 103 16:05:36 SQL Misc: ORACLE - Set rowset size 104 16:05:36 SQL Stmt: ORACLE - Fetch 105 16:05:36 SQL Stmt: ORACLE - EOF 106 16:05:36 SQL Data Out: ORACLE - Column = 1, Name = DTGHCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 107 16:05:36 SQL Data Out: ORACLE - Column = 2, Name = GHKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 普内科 108 16:05:36 SQL Stmt: ORACLE - Reset 109 16:05:36 SQL Stmt: ORACLE - Close 110 16:05:36 SQL Prepare: ORACLE - SELECT CFLSH0, GHH000, BRXM00, XB0000, BRID00, TSYS00, SHBZ00, SHQK00, CSRQ00,YSXM00, GHKS00, ZYTS00, ZYDJS0, GHKSBM, SRRQ01, JZRQ01, CFZJE0, CFZT00,YPDLBH, LRY000, ZZDMC0, BRBLH0, CFDGS0, BZ0000, FYRQ01, FYSJ00, CFZTMC, SRRQ00 FROM VW_YF_MZFYCF c WHERE C.BRID00=:1 AND C.YFBMBH=148 AND ((C.CFZT00 = '1' AND C.JZRQ00>TO_CHAR(SYSDATE-1/3-30,'YYYYMMDD') AND not exists (SELECT 1 FROM YF_MZCF00 D WHERE C.CFLSH0=D.BCCFH0 AND c.GHID00=d.GHID00 AND CFZT00='0')) OR (C.CFZT00 in ('0','4') AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3-3,'YYYYMMDD') AND C.BCCFH0 IS NULL) ) AND C.CFXZ00='0' AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 111 16:05:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 99574.000000 112 16:05:36 SQL Execute: ORACLE - SELECT CFLSH0, GHH000, BRXM00, XB0000, BRID00, TSYS00, SHBZ00, SHQK00, CSRQ00,YSXM00, GHKS00, ZYTS00, ZYDJS0, GHKSBM, SRRQ01, JZRQ01, CFZJE0, CFZT00,YPDLBH, LRY000, ZZDMC0, BRBLH0, CFDGS0, BZ0000, FYRQ01, FYSJ00, CFZTMC, SRRQ00 FROM VW_YF_MZFYCF c WHERE C.BRID00=? AND C.YFBMBH=148 AND ((C.CFZT00 = '1' AND C.JZRQ00>TO_CHAR(SYSDATE-1/3-30,'YYYYMMDD') AND not exists (SELECT 1 FROM YF_MZCF00 D WHERE C.CFLSH0=D.BCCFH0 AND c.GHID00=d.GHID00 AND CFZT00='0')) OR (C.CFZT00 in ('0','4') AND C.SRRQ00>=TO_CHAR(SYSDATE-1/3-3,'YYYYMMDD') AND C.BCCFH0 IS NULL) ) AND C.CFXZ00='0' AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 113 16:05:36 SQL Misc: ORACLE - Set rowset size 114 16:05:36 SQL Stmt: ORACLE - Fetch 115 16:05:36 SQL Stmt: ORACLE - EOF 116 16:05:36 SQL Data Out: ORACLE - Column = 1, Name = CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2543871 117 16:05:36 SQL Data Out: ORACLE - Column = 2, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1942466 118 16:05:36 SQL Data Out: ORACLE - Column = 3, Name = BRXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 洪光明 119 16:05:36 SQL Data Out: ORACLE - Column = 4, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 120 16:05:36 SQL Data Out: ORACLE - Column = 5, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 99574.000000 121 16:05:36 SQL Data Out: ORACLE - Column = 6, Name = TSYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 122 16:05:36 SQL Data Out: ORACLE - Column = 7, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 123 16:05:36 SQL Data Out: ORACLE - Column = 8, Name = SHQK00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 未审核 124 16:05:36 SQL Data Out: ORACLE - Column = 9, Name = CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19520402 125 16:05:36 SQL Data Out: ORACLE - Column = 10, Name = YSXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 林鎏 126 16:05:36 SQL Data Out: ORACLE - Column = 11, Name = GHKS00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 普内科 127 16:05:36 SQL Data Out: ORACLE - Column = 12, Name = ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 128 16:05:36 SQL Data Out: ORACLE - Column = 13, Name = ZYDJS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 129 16:05:36 SQL Data Out: ORACLE - Column = 14, Name = GHKSBM, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 136.000000 130 16:05:36 SQL Data Out: ORACLE - Column = 15, Name = SRRQ01, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.09.20 131 16:05:36 SQL Data Out: ORACLE - Column = 16, Name = JZRQ01, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2012.09.20 132 16:05:36 SQL Data Out: ORACLE - Column = 17, Name = CFZJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 54.930000 133 16:05:36 SQL Data Out: ORACLE - Column = 18, Name = CFZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 134 16:05:36 SQL Data Out: ORACLE - Column = 19, Name = YPDLBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 135 16:05:36 SQL Data Out: ORACLE - Column = 20, Name = LRY000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 林鎏 136 16:05:36 SQL Data Out: ORACLE - Column = 21, Name = ZZDMC0, Type = fldZSTRING, Precision = 240, Scale = 0, Data = 胃炎 137 16:05:36 SQL Data Out: ORACLE - Column = 22, Name = BRBLH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = K52611386 138 16:05:36 SQL Data Out: ORACLE - Column = 23, Name = CFDGS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 139 16:05:36 SQL Data Out: ORACLE - Column = 24, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 140 16:05:36 SQL Data Out: ORACLE - Column = 25, Name = FYRQ01, Type = fldZSTRING, Precision = 10, Scale = 0, Data = .. 141 16:05:36 SQL Data Out: ORACLE - Column = 26, Name = FYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 142 16:05:36 SQL Data Out: ORACLE - Column = 27, Name = CFZTMC, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 已记账 143 16:05:36 SQL Data Out: ORACLE - Column = 28, Name = SRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120920 144 16:05:36 SQL Stmt: ORACLE - Reset 145 16:05:36 SQL Prepare: ORACLE - SELECT X.TSYS00,' ' TSYSMC,CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=:1 AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 146 16:05:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2543871 147 16:05:36 SQL Execute: ORACLE - SELECT X.TSYS00,' ' TSYSMC,CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, CSL000,JLDW00,PCMC00,YFSMMC,YPYFMC,ZJYFMC,XMYFMC, YYSJ00,ZQCD00,YYSJDW,ZB0000,YBLB00,ZFBL00,THBZ00, TRIM(X.YFSMMC)||TRIM(X.YPYFMC)||TRIM(X.XMYFMC)|| TRIM((select '('||p.PSMC00||')' from BM_PS0000 P where p.PSID00=x.PSLBID)) as YYFF00, YYSJ00||TRIM(YYSJDW) as YYTS00,YPNM00,JYSL00,ZHL000,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX X WHERE CFLSH0=? AND SFZBY0='N' AND CXBZ00='Z' order by ZB0000,CFID00 148 16:05:36 SQL Error: ORACLE - ORA-06553: PLS-306: 调用 'OGC_X' 时参数个数或类型错误 149 16:05:36 SQL Error: ORACLE - Unmapped SQL Error Code: 6553 150 16:05:36 SQL Stmt: ORACLE - Reset 151 16:05:36 SQL Data In: ORACLE - Rows affected = 0 152 16:05:36 SQL Stmt: ORACLE - Close