1 15:52:55 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=952 or (JSKSBH=318 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 2 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5436028.000000 3 15:52:58 SQL Execute: ORACLE - select ID0000,SFXMMC,SFJE00,ZCS000,JE0000 from VW_BQ_FJZXXM where YZID00 = ? and TZRQ00 is null and CSLY00 = '2' 4 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5436224.000000 5 15:52:58 SQL Execute: ORACLE - select ID0000,SFXMMC,SFJE00,ZCS000,JE0000 from VW_BQ_FJZXXM where YZID00 = ? and TZRQ00 is null and CSLY00 = '2' 6 15:53:00 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=952 or (JSKSBH=318 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 7 15:53:05 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=952 or (JSKSBH=318 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 8 15:53:06 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where name00 = 'YZ_XZHDHS' 9 15:53:06 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 10 15:53:06 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5436028.000000 11 15:53:06 SQL Data In: ORACLE - Param = 3, Name = P_HDRXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 实达 12 15:53:06 SQL Data In: ORACLE - Param = 4, Name = P_TZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 15:53:06 SQL Data In: ORACLE - Param = 5, Name = P_TZRXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 14 15:53:06 SQL Data In: ORACLE - Param = 6, Name = P_TZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 15:53:06 SQL Data In: ORACLE - Param = 7, Name = P_TZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 16 15:53:06 SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 17 15:53:06 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 15:53:06 SQL Data In: ORACLE - Param = 10, Name = P_CJKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 318 19 15:53:06 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZQT" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_HDRXM0 => :P_HDRXM0,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00,P_CZY000 => :P_CZY000,P_CJKS00 => :P_CJKS00); END; 20 15:53:06 SQL Error: ORACLE - ORA-20002: ORA-20001: 数据没有找到！*ORA-01403: 未找到数据,sp_bq_yzcf00_single('20111022',5436028,'1')！*SP_BQ_YJYZQT(1,5436028,实达,,,,,) ORA-06512: 在"SD_HOSPITAL.SP_BQ_YJYZQT", line 316 ORA-06512: 在line 1 21 15:53:06 SQL Error: ORACLE - Unmapped SQL Error Code: 20002 22 15:53:06 SQL Execute: ORACLE - RollBack 23 15:53:06 SQL Data In: ORACLE - Rows affected = 0 24 15:53:08 SQL Execute: ORACLE - select * from bq_yjyz00 where yzmxid= 5436028 25 15:53:08 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 26 15:53:08 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5436224.000000 27 15:53:08 SQL Data In: ORACLE - Param = 3, Name = P_HDRXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 实达 28 15:53:08 SQL Data In: ORACLE - Param = 4, Name = P_TZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 29 15:53:08 SQL Data In: ORACLE - Param = 5, Name = P_TZRXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 30 15:53:08 SQL Data In: ORACLE - Param = 6, Name = P_TZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 31 15:53:08 SQL Data In: ORACLE - Param = 7, Name = P_TZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 32 15:53:08 SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 33 15:53:08 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 15:53:08 SQL Data In: ORACLE - Param = 10, Name = P_CJKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 318 35 15:53:08 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZQT" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_HDRXM0 => :P_HDRXM0,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00,P_CZY000 => :P_CZY000,P_CJKS00 => :P_CJKS00); END; 36 15:53:08 SQL Error: ORACLE - ORA-20002: ORA-20001: 数据没有找到！*ORA-01403: 未找到数据,sp_bq_yzcf00_single('20111022',5436224,'1')！*SP_BQ_YJYZQT(1,5436224,实达,,,,,) ORA-06512: 在"SD_HOSPITAL.SP_BQ_YJYZQT", line 316 ORA-06512: 在line 1 37 15:53:08 SQL Error: ORACLE - Unmapped SQL Error Code: 20002 38 15:53:08 SQL Execute: ORACLE - RollBack 39 15:53:08 SQL Data In: ORACLE - Rows affected = 0 40 15:53:10 SQL Execute: ORACLE - select * from bq_yjyz00 where yzmxid= 5436224 41 15:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 843882.000000 42 15:53:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 43 15:53:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 843882.000000 44 15:53:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID