1 16:51:32 SQL Execute: ORACLE - select '门诊人数' TJZD00,'8' TJZ000 from dual union all select '急诊人数' TJZD00,'1' TJZ000 from dual union all select '总挂号数' TJZD00,'9' TJZ000 from dual union all select '次均费用' TJZD00,'186.74' TJZ000 from dual union all select '在院人数' TJZD00,'1010' TJZ000 from dual union all select '入院人数' TJZD00,'1' TJZ000 from dual union all select '出院人数' TJZD00,'0' TJZ000 from dual union all select '日均费用' TJZD00,'1.44' TJZ000 from dual union all select '床位占用率' TJZD00,'82.38%' TJZ000 from dual union all select '门收收入' TJZD00,'1680.65' TJZ000 from dual union all select '住收收入' TJZD00,'1450.00' TJZ000 from dual union all select '全院收入' TJZD00,'3130.65' TJZ000 from dual union all select '门诊药品比率' TJZD00,'12.04%' TJZ000 from dual union all select '住院药品比率' TJZD00,'0.00%' TJZ000 from dual union all select '药品比率' TJZD00,'6.46%' TJZ000 from dual 2 16:51:33 SQL Data In: ORACLE - Param = 1, Name = PTJRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201201 3 16:51:33 SQL Data In: ORACLE - Param = 2, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4 16:51:33 SQL Data In: ORACLE - Param = 3, Name = Psfbhjz, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 5 16:51:33 SQL Data In: ORACLE - Param = 4, Name = Ptjqsrq, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 6 16:51:33 SQL Data In: ORACLE - Param = 5, Name = PYYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 16:51:33 SQL Data In: ORACLE - Param = 6, Name = PSFKSTJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 16:51:33 SQL Execute: ORACLE - BEGIN "SP_ZY_CWRBB0" (PTJRQ00 => :PTJRQ00,PID0000 => :PID0000,Psfbhjz => :Psfbhjz,Ptjqsrq => :Ptjqsrq,PYYID00 => :PYYID00,PSFKSTJ => :PSFKSTJ); END; 9 16:51:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 853414.000000 10 16:51:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 11 16:51:33 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 853414.000000 12 16:51:33 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 13 16:51:33 SQL Execute: ORACLE - SELECT -9999 NO0000,SUM(to_number(GHKS02)) BQSYCW,SUM(to_number(GHKS03)) BQZYCW,'全院' BMMC00, sum(to_number(GHKS01)) SYCW00,sum(to_number(GHKS05)) BQBCS0,sum(to_number(GHKS09)) RJCWS0 ,SUM(to_number(GHKS10)) BQZBCW ,GHKS11 from BM_GHKSTJ where ID0000=? and nvl(GHKS07,0)=0 and nvl(GHKS08,'0')<>? group by GHKS11 union all select b.pxxh00 NO0000,to_number(GHKS02) BQSYCW,to_number(GHKS03) BQZYCW,trim(GHRQ00) BMMC00,to_number(GHKS01) SYCW00, to_number(GHKS05) BQBCS0 ,to_number(GHKS09) RJCWS0 ,to_number(GHKS10) BQZBCW ,to_number(GHKS11) BQZBCW from BM_GHKSTJ a,Bm_Bmbm00 b where trim(a.GHRQ00)=b.bmmc00 and ID0000=? and nvl(GHKS08,'0')<>? order by NO0000 14 16:51:33 SQL Execute: ORACLE - rollback 15 16:51:33 SQL Data In: ORACLE - Rows affected = 0 16 16:51:33 SQL Execute: ORACLE - Delete from BM_ZHTJ00_TEMP00 where trim(Flag00)=trim('SUMDATE0119') 17 16:51:33 SQL Data In: ORACLE - Rows affected = 0 18 16:51:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = SUMDATE0119 19 16:51:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201201 20 16:51:33 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20201215 21 16:51:33 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 22 16:51:33 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 23 16:51:33 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 24 16:51:33 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 25 16:51:33 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 26 16:51:33 SQL Execute: ORACLE - Insert into BM_ZHTJ00_TEMP00(flag00,STARTD,STOPDA,STARTT,STOPTI,TEMP90,TEMP91,TEMP92) values(?,?,?,?,?,?,?,?) 27 16:51:33 SQL Data In: ORACLE - Rows affected = 1 28 16:51:33 SQL Execute: ORACLE - Commit 29 16:51:33 SQL Data In: ORACLE - Rows affected = 0 30 16:51:33 SQL Execute: ORACLE - select b.LBBH00 lbbh00,b.LBMC00 from SF_BRXXB0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 and a.GHLB00>=0 and a.GHRQ00 between '20201201' and '20201215' group by b.LBBH00,b.LBMC00 union all select -9999 lbbh00,'合计' from dual union all select 9999 lbbh00,'其它' from dual order by lbbh00 31 16:51:34 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = S_MZZHCX0119 32 16:51:34 SQL Data In: ORACLE - Param = 2, Name = V_KSYSBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 33 16:51:34 SQL Execute: ORACLE - BEGIN "SP_ZH_MZXXCX" (V_FLAG00 => :V_FLAG00,V_KSYSBZ => :V_KSYSBZ); END; 34 16:51:34 SQL Error: ORACLE - ORA-20001: 插入数据错误！*SP_ZH_MZXXCX(S_MZZHCX0119,1)*-20910ORA-209 ORA-06512: 在 "SD_HOSPITAL.SP_ZH_MZXXCX", line 913 ORA-06512: 在 line 1 35 16:51:34 SQL Error: ORACLE - Unmapped SQL Error Code: 20001