1 10:35:14 SQL Prepare: ORACLE - Select SYSDATE from Dual 2 10:35:14 SQL Execute: ORACLE - Select SYSDATE from Dual 3 10:35:14 SQL Data Out: ORACLE - Column = 1, Name = SYSDATE, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 7/13/2011 10:35:15:0 4 10:35:14 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 10:35:14 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 6 10:35:14 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 52 7 10:35:14 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') 8 10:35:14 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') 9 10:35:14 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = SLE4442 10 10:35:14 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 10:35:14 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 12 10:35:14 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK52525568' and ICKNBH = 'FZYBK52525568' 13 10:35:14 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK52525568' and ICKNBH = 'FZYBK52525568' 14 10:35:14 SQL Data Out: ORACLE - Column = 1, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = FZYBK52525568 15 10:35:14 SQL Data Out: ORACLE - Column = 2, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 16 10:35:14 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 1471453.000000 17 10:35:14 SQL Data Out: ORACLE - Column = 4, Name = KMH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = K52525568 18 10:35:14 SQL Data Out: ORACLE - Column = 5, Name = ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 19 10:35:14 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 20 10:35:14 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1471453.000000 21 10:35:14 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 10:35:14 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 23 10:35:14 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 10:35:14 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 10:35:14 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 10:35:14 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 10:35:14 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 28 10:35:14 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 29 10:35:14 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 10:35:14 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 10:35:14 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 10:35:14 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 10:35:14 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 10:35:14 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 35 10:35:14 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 36 10:35:14 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 10:35:14 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 38 10:35:14 SQL Prepare: ORACLE - Select brid00,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,xmzt00,csrq00,lrxm00,kdsj00,zje000, mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,yzcfid,dcbz00 from vw_yj_yw0000_kcx b where xmzt00 not in('0','6','7') and brid00=1471453 and mzzybz='0' and YJKSBH+0=163 and SL0000>CXSL00 and SL0000>0 and SFDJH0<>0 and XMZT00 <>'1' and ((yjlrbz='Y') or (zxsl00<>0)) and kdrq00 between '20110711' and '20110713' order by yjdjh0 39 10:35:14 SQL Execute: ORACLE - Select brid00,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,xmzt00,csrq00,lrxm00,kdsj00,zje000, mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,yzcfid,dcbz00 from vw_yj_yw0000_kcx b where xmzt00 not in('0','6','7') and brid00=1471453 and mzzybz='0' and YJKSBH+0=163 and SL0000>CXSL00 and SL0000>0 and SFDJH0<>0 and XMZT00 <>'1' and ((yjlrbz='Y') or (zxsl00<>0)) and kdrq00 between '20110711' and '20110713' order by yjdjh0 40 10:35:14 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 41 10:35:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 10:35:14 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 43 10:35:16 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 44 10:35:16 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 10:35:16 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0 46 10:35:16 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 8438191 47 10:35:16 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 10:35:16 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 49 10:35:16 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 50 10:35:16 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 10:35:16 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 10:35:16 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 53 10:35:16 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 54 10:35:16 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 10:35:16 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 56 10:35:16 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 57 10:35:16 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 10:35:16 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 59 10:35:16 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 60 10:35:16 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 61 10:35:16 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 62 10:35:16 SQL Prepare: ORACLE - Select brid00,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,xmzt00,csrq00,lrxm00,kdsj00,zje000, mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,yzcfid,dcbz00 from vw_yj_yw0000_kcx b where xmzt00 not in('0','6','7') and brid00=1471453 and mzzybz='0' and YJKSBH+0=163 and (Exists(select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh) or ((cxdjh0<>0) and (cxdjh0 is not null))) and kdrq00 between '20110711' and '20110713' order by yjdjh0 63 10:35:16 SQL Execute: ORACLE - Select brid00,yjdjh0,yjfzh0,zyhghh,brxm00,yexm00,zlxmjc,xb0000,xmzt00,csrq00,lrxm00,kdsj00,zje000, mzzybz,kdysxm,kdksmc,kdrq00,jzbz00,bwmc00,bz0000,zdmc00,sl0000,zxsl00,cxdjh0,cxsl00,yzcfid,dcbz00 from vw_yj_yw0000_kcx b where xmzt00 not in('0','6','7') and brid00=1471453 and mzzybz='0' and YJKSBH+0=163 and (Exists(select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh) or ((cxdjh0<>0) and (cxdjh0 is not null))) and kdrq00 between '20110711' and '20110713' order by yjdjh0 64 10:35:16 SQL Data Out: ORACLE - Column = 1, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 1471453.000000 65 10:35:16 SQL Data Out: ORACLE - Column = 2, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 23036299.000000 66 10:35:16 SQL Data Out: ORACLE - Column = 3, Name = YJFZH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 67 10:35:16 SQL Data Out: ORACLE - Column = 4, Name = ZYHGHH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 8399026 68 10:35:16 SQL Data Out: ORACLE - Column = 5, Name = BRXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 李宝花 69 10:35:16 SQL Data Out: ORACLE - Column = 6, Name = YEXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 70 10:35:16 SQL Data Out: ORACLE - Column = 7, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 胃镜套餐1（加病理） 71 10:35:16 SQL Data Out: ORACLE - Column = 8, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 女 72 10:35:16 SQL Data Out: ORACLE - Column = 9, Name = XMZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 73 10:35:16 SQL Data Out: ORACLE - Column = 10, Name = CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620327 74 10:35:16 SQL Data Out: ORACLE - Column = 11, Name = LRXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 金宇玲 75 10:35:16 SQL Data Out: ORACLE - Column = 12, Name = KDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:08:48 76 10:35:16 SQL Data Out: ORACLE - Column = 13, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -272.000000 77 10:35:16 SQL Data Out: ORACLE - Column = 14, Name = MZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 78 10:35:16 SQL Data Out: ORACLE - Column = 15, Name = KDYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 唐福康 79 10:35:16 SQL Data Out: ORACLE - Column = 16, Name = KDKSMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 门诊脾胃病组 80 10:35:16 SQL Data Out: ORACLE - Column = 17, Name = KDRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110713 81 10:35:16 SQL Data Out: ORACLE - Column = 18, Name = JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 82 10:35:16 SQL Data Out: ORACLE - Column = 19, Name = BWMC00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 83 10:35:16 SQL Data Out: ORACLE - Column = 20, Name = BZ0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 84 10:35:16 SQL Data Out: ORACLE - Column = 21, Name = ZDMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 胃病 85 10:35:16 SQL Data Out: ORACLE - Column = 22, Name = SL0000, Type = fldFLOAT, Precision = 7, Scale = 2, Data = -1.000000 86 10:35:16 SQL Data Out: ORACLE - Column = 23, Name = ZXSL00, Type = fldFLOAT, Precision = 7, Scale = 2, Data = -1.000000 87 10:35:16 SQL Data Out: ORACLE - Column = 24, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 22874288.000000 88 10:35:16 SQL Data Out: ORACLE - Column = 25, Name = CXSL00, Type = fldFLOAT, Precision = 7, Scale = 2, Data = 0.000000 89 10:35:16 SQL Data Out: ORACLE - Column = 26, Name = YZCFID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 90 10:35:16 SQL Data Out: ORACLE - Column = 27, Name = DCBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 91 10:35:16 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=:1 92 10:35:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23036299.000000 93 10:35:16 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,sl0000 from yj_ywmx00 where yjdjh0=? 94 10:35:16 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 23036299.000000 95 10:35:16 SQL Data Out: ORACLE - Column = 2, Name = ZLXMID, Type = fldFLOAT, Precision = 8, Scale = 0, Data = 20737.000000 96 10:35:16 SQL Data Out: ORACLE - Column = 3, Name = XMMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 胃镜套餐1（加病理） 97 10:35:16 SQL Data Out: ORACLE - Column = 4, Name = JGDW00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 98 10:35:16 SQL Data Out: ORACLE - Column = 5, Name = CKZ000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 99 10:35:16 SQL Data Out: ORACLE - Column = 6, Name = BZ0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 100 10:35:16 SQL Data Out: ORACLE - Column = 7, Name = ID0000, Type = fldFLOAT, Precision = 11, Scale = 0, Data = 20100600.000000 101 10:35:16 SQL Data Out: ORACLE - Column = 8, Name = SL0000, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 1.000000 102 10:35:23 SQL Prepare: ORACLE - BEGIN "SP_YJ_CXCX00_BFCX00" (PYJDJH0 => :PYJDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0); END; 103 10:35:23 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23036299 104 10:35:23 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1372.000000 105 10:35:23 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 163.000000 106 10:35:23 SQL Execute: ORACLE - BEGIN "SP_YJ_CXCX00_BFCX00" (PYJDJH0 => :PYJDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0); END; 107 10:35:23 SQL Error: ORACLE - ORA-20020: ORA-20020: ORA-20001: 数据没有找到！*ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_YJ_YW0000_ADEL", line 22 ORA-04088: 触发器 'SD_HOSPITAL.TR_YJ_YW0000_ADEL' 执行过程中出错 ORA-06512: 在 "SD_HOSPITAL.SP_YJ_CXCX00_BFCX00", line 93 ORA-06512: 在 line 1 108 10:35:23 SQL Error: ORACLE - Unmapped SQL Error Code: 20020