1 09:08:12 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220501 2 09:08:12 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220531 3 09:08:12 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:01 4 09:08:12 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:00 5 09:08:12 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 6 09:08:12 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 09:08:12 SQL Data In: ORACLE - Param = 7, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 8 09:08:12 SQL Data In: ORACLE - Param = 8, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 9 09:08:12 SQL Data In: ORACLE - Param = 9, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 10 09:08:12 SQL Data In: ORACLE - Param = 10, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 11 09:08:12 SQL Data In: ORACLE - Param = 11, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 12 09:08:12 SQL Data In: ORACLE - Param = 12, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 09:08:12 SQL Data In: ORACLE - Param = 13, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 09:08:12 SQL Data In: ORACLE - Param = 14, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 09:08:12 SQL Data In: ORACLE - Param = 15, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 16 09:08:12 SQL Data In: ORACLE - Param = 16, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 17 09:08:12 SQL Data In: ORACLE - Param = 17, Name = as_SFKCGF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 18 09:08:12 SQL Data In: ORACLE - Param = 18, Name = as_HSFDBF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 19 09:08:12 SQL Data In: ORACLE - Param = 19, Name = as_IFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 20 09:08:12 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF,as_HSFDBF => :as_HSFDBF,as_IFJZFP => :as_IFJZFP); END; 21 09:08:13 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220501 22 09:08:13 SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:01 23 09:08:13 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220531 24 09:08:13 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:00 25 09:08:13 SQL Data In: ORACLE - Param = 5, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 26 09:08:13 SQL Data In: ORACLE - Param = 6, Name = AS_YBMC00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 27 09:08:13 SQL Data In: ORACLE - Param = 7, Name = AS_JZR000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有记帐人 28 09:08:13 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 09:08:13 SQL Data In: ORACLE - Param = 9, Name = AS_ZTJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 30 09:08:13 SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 31 09:08:13 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 09:08:13 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 09:08:13 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 34 09:08:13 SQL Data In: ORACLE - Param = 14, Name = as_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 35 09:08:13 SQL Data In: ORACLE - Param = 15, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 36 09:08:13 SQL Data In: ORACLE - Param = 16, Name = as_SFKCGF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 37 09:08:13 SQL Data In: ORACLE - Param = 17, Name = as_HSFDBF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 38 09:08:13 SQL Data In: ORACLE - Param = 18, Name = as_IFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 09:08:13 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,as_BRYBZX => :as_BRYBZX,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFDZX0 => :as_SFDZX0,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF,as_HSFDBF => :as_HSFDBF,as_IFJZFP => :as_IFJZFP); END; 40 09:08:13 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220501 41 09:08:13 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220531 42 09:08:13 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:01 43 09:08:13 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:00 44 09:08:13 SQL Data In: ORACLE - Param = 5, Name = AS_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 45 09:08:13 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 46 09:08:13 SQL Data In: ORACLE - Param = 7, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 47 09:08:13 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 48 09:08:13 SQL Data In: ORACLE - Param = 9, Name = AS_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 49 09:08:13 SQL Data In: ORACLE - Param = 10, Name = AS_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 50 09:08:13 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 51 09:08:13 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 52 09:08:13 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 53 09:08:13 SQL Data In: ORACLE - Param = 14, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 54 09:08:13 SQL Data In: ORACLE - Param = 15, Name = as_SFKCGF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 55 09:08:13 SQL Data In: ORACLE - Param = 16, Name = as_HSFDBF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 09:08:13 SQL Data In: ORACLE - Param = 17, Name = as_IFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 57 09:08:13 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_DBZTJB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_BRYBZX => :AS_BRYBZX,AS_YBZXMC => :AS_YBZXMC,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_TJFS00 => :AS_TJFS00,AS_SFDZX0 => :AS_SFDZX0,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF,as_HSFDBF => :as_HSFDBF,as_IFJZFP => :as_IFJZFP); END; 58 09:08:13 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220501 59 09:08:13 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220531 60 09:08:13 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:01 61 09:08:13 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:30:00 62 09:08:13 SQL Data In: ORACLE - Param = 5, Name = AS_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 63 09:08:13 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 所有医保病人 64 09:08:13 SQL Data In: ORACLE - Param = 7, Name = AS_BQMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病区 65 09:08:13 SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 66 09:08:13 SQL Data In: ORACLE - Param = 9, Name = AS_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 09:08:13 SQL Data In: ORACLE - Param = 10, Name = AS_SFDZX0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 68 09:08:13 SQL Data In: ORACLE - Param = 11, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 09:08:13 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 70 09:08:13 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 71 09:08:13 SQL Data In: ORACLE - Param = 14, Name = as_WSQK00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 72 09:08:13 SQL Data In: ORACLE - Param = 15, Name = as_SFKCGF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 73 09:08:13 SQL Data In: ORACLE - Param = 16, Name = as_HSFDBF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 74 09:08:13 SQL Data In: ORACLE - Param = 17, Name = as_IFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 75 09:08:13 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_TSBZTJB" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_BRYBZX => :AS_BRYBZX,AS_YBZXMC => :AS_YBZXMC,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_TJFS00 => :AS_TJFS00,AS_SFDZX0 => :AS_SFDZX0,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_WSQK00 => :as_WSQK00,as_SFKCGF => :as_SFKCGF,as_HSFDBF => :as_HSFDBF,as_IFJZFP => :as_IFJZFP); END; 76 09:08:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5016791.000000 77 09:08:14 SQL Execute: ORACLE - select aa.* from ( select decode(a.GHKS18,999999999,a.GHRQ00,f.ybmc00)ybmc00, decode(a.GHKS18,999999999,' ',substrb(SF_ZY_BRLXMC(a.GHKS18),1,20)) BRLXMC, decode(a.GHKS18,999999999,' ',substrb(SF_ZY_BRCYZYZDMC(GHKS18),1,120))JBMC00, B.BRXM00,B.BRXB00,E.YBKH00,e.YBZYH0,E.zyh000 as MRN000, B.BRZTQK,B.TYDWMC,E.CYRQ00,E.CYSJ00,a.BEIZHU as ZWXM00,GHKS18 as zyid00,GHKS01 as brid00, (select BMMC00 from bm_bmbm00 aa where aa.bmbh00=e.dqbq00 and rownum=1)BMMC00, (select BMMC00 from bm_bmbm00 aa where aa.bmbh00=e.dqks00 and rownum=1)KSMC00, e.SXYSXM JGYS00,GHKS30 as RS0000, a.GHKS88 as HJJE00,a.XMHJ00 as YBXJ00,a.GHKS03 as ZFJE00,a.GHKS04 as GRZHZF,a.GHKS05 as TCJJZF, a.GHKS06 as SBGRZH,a.GHKS07 as SBTCJJ,a.GHKS08 as JZJE00,a.GHKS09 as JMJE00,a.GHKS11 as ZYTS00, a.GHKS13 as JJZFE0,a.GHKS14 as SYBXZF,a.GHKS15 as SBZFE0, a.GHKS16 as BJZFE0,a.GHKS19 as GWYBZ0, a.GHKS21 as YPWQZF,a.GHKS22 as XMWQZF,a.GHKS23 as YPBFZF,a.GHKS24 as XMBFZF,a.GHKS25 as YPFY00, a.GHKS26 as mzjzje,a.GHKS32 as mzbzje,a.GHKS27 as yyzfje,a.GHKS28 as QZFJE0,a.GHKS29 as BFQZF0, E.SJRYRQ,E.SJCYRQ,a.GHKS31 as DBBCJE, decode(E.SFJZFP, '1', '是', '否') SFJZFP,E.SJRYSJ,E.SJCYSJ,E.CYRQ00||' '||E.CYSJ00 JSSJ00, nvl(to_char(round(a.GHKS05/a.GHKS88*100,2),'FM99990.00'),'0.00')||'%' BXBL00 from BM_GHKSTJ a ,bm_brxxb0 b,ZY_BRXXB0 E ,IC_YBBRLB f where a.id0000=? and a.DYID00=2 and A.GHKS18=E.ZYID00(+) and e.brid00=b.brid00(+) and e.FBBH00 = f.FBBH00(+) and e.YBLB00 = f.YBLB00(+) ) aa order by BMMC00,ybmc00 78 09:08:14 SQL Error: ORACLE - ORA-01476: 除数为 0 79 09:08:14 SQL Error: ORACLE - Unmapped SQL Error Code: 1476 80 09:08:14 SQL Data In: ORACLE - Rows affected = 0