1 14:56:19 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '8') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',33,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',132,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =132 AND b.JSKSBH = '33') AND (INSTR (',' || a.jsksbh || ',',',33,') > 0 or a.jsksbh is null) 2 14:56:27 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='10921814' and LBBH00='0' 3 14:56:27 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='3984875' and ZT0000='1' 4 14:56:27 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='3984875' and ZT0000='1' 5 14:56:27 SQL Execute: ORACLE - Select SYSDATE from Dual 6 14:56:27 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 7 14:56:27 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') 8 14:56:28 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222137600693370' and ICKNBH = '0222137600693370' 9 14:56:28 SQL Execute: ORACLE - Select LPAD(To_Char(SQ_YJ_YW0000_YJDJH0.NextVal),10,'0') Val from Dual 10 14:56:28 SQL Execute: ORACLE - Select LPAD(To_Char(SQ_YJ_YW0000_YJDJH0.NextVal),10,'0') Val from Dual 11 14:56:28 SQL Execute: ORACLE - Select LPAD(To_Char(SQ_YJ_YW0000_YJDJH0.NextVal),10,'0') Val from Dual 12 14:56:28 SQL Execute: ORACLE - select YJDJH0 from YJ_YW0000 where XMZT00 in ('2','3','4') and YJDJH0 in (28672001,28672002,28672003) 13 14:56:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 28672001 14 14:56:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 15 14:56:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 16 14:56:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 17 14:56:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 18 14:56:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3874 19 14:56:28 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 20 14:56:28 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 46 21 14:56:28 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 132 22 14:56:28 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 23 14:56:28 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 31 24 14:56:28 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 25 14:56:28 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 26 14:56:28 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 27 14:56:28 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 14:56:28 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 29 14:56:28 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 14:56:28 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 31 14:56:28 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 32 14:56:28 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 14:56:28 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 糖尿病 34 14:56:28 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 35 14:56:28 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 36 14:56:28 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 37 14:56:28 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 14:56:28 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 39 14:56:28 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 14:56:28 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0, YJFZH0, BRID00, ZYGHID, MZZYBZ, ZLXMID, SL0000, YJKSBH,KDYS00,KDKSBH, YSSZKS, KDRQ00, KDSJ00, LRXM00, JZBZ00, BWMC00, ZDID00,ZDMC00, XMZT00, YZCFID, DCBZ00,JCQZY0,mc0000,bh0000,ZSDYMC,TSBSMC,BZ0000,BBID00,BWBH00)values(?, ?, ?, ?, ?, ?, ?, ?,?,?, ?, to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'), ?, ?,?, ?, ?,?, ?, ?,?,?,?,?, ?,?,?,?) 41 14:56:28 SQL Data In: ORACLE - Rows affected = 1 42 14:56:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 28672002 43 14:56:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 44 14:56:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 45 14:56:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 46 14:56:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 14:56:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 7623 48 14:56:28 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 49 14:56:28 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 46 50 14:56:28 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 132 51 14:56:28 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 52 14:56:28 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 31 53 14:56:28 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 54 14:56:28 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 55 14:56:28 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 56 14:56:28 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 14:56:28 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 14:56:28 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 59 14:56:28 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 60 14:56:28 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 61 14:56:28 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 14:56:28 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 糖尿病 63 14:56:28 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 64 14:56:28 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 65 14:56:28 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 14:56:28 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 67 14:56:28 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 14:56:28 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 69 14:56:28 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0, YJFZH0, BRID00, ZYGHID, MZZYBZ, ZLXMID, SL0000, YJKSBH,KDYS00,KDKSBH, YSSZKS, KDRQ00, KDSJ00, LRXM00, JZBZ00, BWMC00, ZDID00,ZDMC00, XMZT00, YZCFID, DCBZ00,JCQZY0,mc0000,bh0000,ZSDYMC,TSBSMC,BZ0000,BBID00,BWBH00)values(?, ?, ?, ?, ?, ?, ?, ?,?,?, ?, to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'), ?, ?,?, ?, ?,?, ?, ?,?,?,?,?, ?,?,?,?) 70 14:56:28 SQL Data In: ORACLE - Rows affected = 1 71 14:56:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 28672003 72 14:56:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 73 14:56:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 74 14:56:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 75 14:56:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 76 14:56:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 22767 77 14:56:28 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 78 14:56:28 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 46 79 14:56:28 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 132 80 14:56:28 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 81 14:56:28 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 31 82 14:56:28 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 83 14:56:28 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 84 14:56:28 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 85 14:56:28 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 86 14:56:28 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 87 14:56:28 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 88 14:56:28 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 89 14:56:28 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 90 14:56:28 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 14:56:28 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 糖尿病 92 14:56:28 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 93 14:56:28 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 94 14:56:28 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 95 14:56:28 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 96 14:56:28 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 97 14:56:28 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 14:56:28 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0, YJFZH0, BRID00, ZYGHID, MZZYBZ, ZLXMID, SL0000, YJKSBH,KDYS00,KDKSBH, YSSZKS, KDRQ00, KDSJ00, LRXM00, JZBZ00, BWMC00, ZDID00,ZDMC00, XMZT00, YZCFID, DCBZ00,JCQZY0,mc0000,bh0000,ZSDYMC,TSBSMC,BZ0000,BBID00,BWBH00)values(?, ?, ?, ?, ?, ?, ?, ?,?,?, ?, to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'), ?, ?,?, ?, ?,?, ?, ?,?,?,?,?, ?,?,?,?) 99 14:56:28 SQL Data In: ORACLE - Rows affected = 1 100 14:56:28 SQL Execute: ORACLE - Delete from YJ_YWMX00 where YJDJH0=28672001 101 14:56:28 SQL Data In: ORACLE - Rows affected = 0 102 14:56:28 SQL Execute: ORACLE - insert into YJ_YWMX00 (ID0000,YJDJH0,ZLXMID,JGDW00,CKZ000)SELECT SQ_YJ_YWMX00_ID0000.Nextval,28672001,ZXMID0,JGDW00,CKZ000 FROM VW_YS_YWMXXM WHERE GDXMBZ='Y' and SJXMID=3874 103 14:56:28 SQL Data In: ORACLE - Rows affected = 1 104 14:56:28 SQL Execute: ORACLE - Delete from YJ_YWMX00 where YJDJH0=28672002 105 14:56:28 SQL Data In: ORACLE - Rows affected = 0 106 14:56:28 SQL Execute: ORACLE - insert into YJ_YWMX00 (ID0000,YJDJH0,ZLXMID,JGDW00,CKZ000)SELECT SQ_YJ_YWMX00_ID0000.Nextval,28672002,ZXMID0,JGDW00,CKZ000 FROM VW_YS_YWMXXM WHERE GDXMBZ='Y' and SJXMID=7623 107 14:56:28 SQL Data In: ORACLE - Rows affected = 1 108 14:56:28 SQL Execute: ORACLE - Delete from YJ_YWMX00 where YJDJH0=28672003 109 14:56:28 SQL Data In: ORACLE - Rows affected = 0 110 14:56:28 SQL Execute: ORACLE - insert into YJ_YWMX00 (ID0000,YJDJH0,ZLXMID,JGDW00,CKZ000)SELECT SQ_YJ_YWMX00_ID0000.Nextval,28672003,ZXMID0,JGDW00,CKZ000 FROM VW_YS_YWMXXM WHERE GDXMBZ='Y' and SJXMID=22767 111 14:56:28 SQL Data In: ORACLE - Rows affected = 1 112 14:56:28 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28672001.000000 113 14:56:28 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 114 14:56:28 SQL Data In: ORACLE - Param = 3, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 132.000000 115 14:56:28 SQL Data In: ORACLE - Param = 4, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 116 14:56:28 SQL Data In: ORACLE - Param = 5, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 117 14:56:28 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 118 14:56:28 SQL Data In: ORACLE - Param = 7, Name = AS_MZH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10921814 119 14:56:28 SQL Data In: ORACLE - Param = 8, Name = AD_MZID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 120 14:56:28 SQL Data In: ORACLE - Param = 9, Name = PBH0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 121 14:56:28 SQL Execute: ORACLE - BEGIN "SP_YS_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_BRID00 => :AD_BRID00,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,PBH0000 => :PBH0000); END; 122 14:56:28 SQL Error: ORACLE - ORA-20010: 定价过程出错，数据没有找到* ORA-06512: 在 "SD_HOSPITAL.SP_YS_YJ_YWJJ00", line 142 ORA-06512: 在 line 1 123 14:56:28 SQL Error: ORACLE - Unmapped SQL Error Code: 20010 124 14:56:28 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28672002.000000 125 14:56:28 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 126 14:56:28 SQL Data In: ORACLE - Param = 3, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 132.000000 127 14:56:28 SQL Data In: ORACLE - Param = 4, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 128 14:56:28 SQL Data In: ORACLE - Param = 5, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 129 14:56:28 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 130 14:56:28 SQL Data In: ORACLE - Param = 7, Name = AS_MZH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10921814 131 14:56:28 SQL Data In: ORACLE - Param = 8, Name = AD_MZID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 132 14:56:28 SQL Data In: ORACLE - Param = 9, Name = PBH0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 133 14:56:28 SQL Execute: ORACLE - BEGIN "SP_YS_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_BRID00 => :AD_BRID00,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,PBH0000 => :PBH0000); END; 134 14:56:28 SQL Error: ORACLE - ORA-20010: 定价过程出错，数据没有找到* ORA-06512: 在 "SD_HOSPITAL.SP_YS_YJ_YWJJ00", line 142 ORA-06512: 在 line 1 135 14:56:28 SQL Error: ORACLE - Unmapped SQL Error Code: 20010 136 14:56:28 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28672003.000000 137 14:56:28 SQL Data In: ORACLE - Param = 2, Name = PCXJJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 138 14:56:28 SQL Data In: ORACLE - Param = 3, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 132.000000 139 14:56:28 SQL Data In: ORACLE - Param = 4, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林瑞钦 140 14:56:28 SQL Data In: ORACLE - Param = 5, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000 141 14:56:28 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 142 14:56:28 SQL Data In: ORACLE - Param = 7, Name = AS_MZH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10921814 143 14:56:28 SQL Data In: ORACLE - Param = 8, Name = AD_MZID00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24028161 144 14:56:28 SQL Data In: ORACLE - Param = 9, Name = PBH0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00000006 145 14:56:28 SQL Execute: ORACLE - BEGIN "SP_YS_YJ_YWJJ00" (PYJDJH0 => :PYJDJH0,PCXJJ00 => :PCXJJ00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_BRID00 => :AD_BRID00,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,PBH0000 => :PBH0000); END; 146 14:56:28 SQL Error: ORACLE - ORA-20010: 定价过程出错，数据没有找到* ORA-06512: 在 "SD_HOSPITAL.SP_YS_YJ_YWJJ00", line 142 ORA-06512: 在 line 1 147 14:56:28 SQL Error: ORACLE - Unmapped SQL Error Code: 20010 148 14:56:28 SQL Data In: ORACLE - Param = 1, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24028161.000000 149 14:56:28 SQL Data In: ORACLE - Param = 2, Name = V_YJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 150 14:56:28 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 151 14:56:28 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 152 14:56:28 SQL Execute: ORACLE - BEGIN "SP_YS_YJTSXZ" (V_GHID00 => :V_GHID00,V_YJDJH0 => :V_YJDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 153 14:56:28 SQL Execute: ORACLE - Commit 154 14:56:28 SQL Data In: ORACLE - Rows affected = 0 155 14:56:28 SQL Execute: ORACLE - commit 156 14:56:28 SQL Data In: ORACLE - Rows affected = 0 157 14:56:28 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC,'0' XGBZ00, decode(a.jcqzy0,null,(select jcqzysx from bm_zlzd00 where zlxmid=a.zlxmid),a.jcqzy0) JCQZYSX,c.LBBH00 ,nvl(c.JCLBID,0) JCLBID,nvl(c.SQDID0,0) SQDID0,'0' as yjmxzt,decode(nvl(a.SQID00,0),0,'未申请','已申请:'||a.SQID00) SQZT00,a.YJDJH0 YJDJH1,c.BWBH00 WHBWBH,a.BWBH00 OLDBW0,a.ZLXMJC OLDMC0 from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.MZZYBZ='0' and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.ZYHGHH='10921814' and a.SL0000>0 and (a.XMZT00='0' or a.XMZT00='1' or a.XMZT00='5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='10921814') order by a.YJDJH0 158 14:56:28 SQL Execute: ORACLE - select a.*,b.BMMC00 as BMMC from YJ_YW0000 a,BM_BMBM00 b,bm_zlzd00 c where a.YJKSBH=b.BMBH00 and a.zlxmid=c.zlxmid and c.lbbh00 not in ('0') and a.MZZYBZ='0' and a.ZYHGHH='10921814' and a.SL0000>0 and (a.XMZT00<>'0' and a.XMZT00<>'1' and a.XMZT00<>'5') and not exists (select 'a' from yj_yw0000 d where d.cxdjh0=a.yjdjh0 and d.ZYHGHH='10921814') order by a.YJDJH0 159 14:56:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 10921814 160 14:56:28 SQL Execute: ORACLE - select THBZ00 from SF_BRXXB0 where GHH000=? and GHH000 is not null 161 14:56:28 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_BBZD00 B 162 14:56:29 SQL Execute: ORACLE - select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B where A.zlxmid=3874 AND A.BBID00=B.BBID00 order by a.XH0000 163 14:56:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 10921814 164 14:56:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 10921814 165 14:56:29 SQL Execute: ORACLE - select sum(CFZJE0) from VW_YS_CFZL00 where CFBZ00='1' and GHH000=? and zt0000 in ('0') union all select sum(ZJE000) from YJ_YW0000 where ZYHGHH=? and MZZYBZ='0' and xmzt00 in ('0','1') 166 14:56:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3984875 167 14:56:29 SQL Execute: ORACLE - select a.ZYE000,a.KYJE00,b.YBZHYE from VW_YS_BRXXB0 a,SF_BRZHXX b where a.brid00=? and a.BRID00=b.BRID00 168 14:56:29 SQL Execute: ORACLE - select * from VW_YS_CFSHJG where GHID00=24028161 and MZZYBZ='0' order by CZRQ00||CZSJ00 desc 169 14:56:29 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '8') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',33,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',132,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =132 AND b.JSKSBH = '33') AND (INSTR (',' || a.jsksbh || ',',',33,') > 0 or a.jsksbh is null)