1 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 2 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 3 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6461.000000 4 14:54:57 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,a.YBBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 5 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6461.000000 6 14:54:57 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 7 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 8 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 9 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 10 14:54:57 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,a.YBBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 11 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 12 14:54:57 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 13 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 14 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 15 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 16 14:54:57 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,a.YBBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 17 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 18 14:54:57 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 19 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 20 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 21 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 22 14:54:57 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,a.YBBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB 23 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 24 14:54:57 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 25 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 10102027118476910501 26 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 27 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 28 14:54:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 29 14:54:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 30 14:54:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 31 14:54:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 32 14:54:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 33 14:54:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6461.000000 34 14:54:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 35 14:54:57 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 36 14:54:57 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 37 14:54:57 SQL Execute: ORACLE - update BM_YBSFDY set YBXMBH=?, YBZYFP =? , YBMZFP = ?, SFYBXM = ?, YBLB00=?, ZFBL00 = ?, BZ0000=?, YBBRLB=? WHERE SFXMID = ? and SFYP00 =? and YBZXLB = ? and FBBH00 = ? 38 14:54:57 SQL Data In: ORACLE - Rows affected = 1 39 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 11207005109051010101 40 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 41 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 42 14:54:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 43 14:54:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 44 14:54:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 45 14:54:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 46 14:54:57 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Z 47 14:54:57 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 48 14:54:57 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 49 14:54:57 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 50 14:54:57 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 51 14:54:57 SQL Execute: ORACLE - update BM_YBSFDY set YBXMBH=?, YBZYFP =? , YBMZFP = ?, SFYBXM = ?, YBLB00=?, ZFBL00 = ?, BZ0000=?, YBBRLB=? WHERE SFXMID = ? and SFYP00 =? and YBZXLB = ? and FBBH00 = ? 52 14:54:57 SQL Error: ORACLE - ORA-20001: 11111111111111 ORA-06512: 在 "SD_HOSPITAL.TR_BM_YBSFDY_UPDATELNYY", line 10 ORA-04088: 触发器 'SD_HOSPITAL.TR_BM_YBSFDY_UPDATELNYY' 执行过程中出错 53 14:54:57 SQL Error: ORACLE - Unmapped SQL Error Code: 20001 54 14:54:57 SQL Execute: ORACLE - ROLLBACK WORK 55 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 56 14:54:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 57 14:54:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 58 14:54:57 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 59 14:54:57 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 60 14:54:57 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 61 14:54:57 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 62 14:54:57 SQL Execute: ORACLE - SELECT fbbh00, SFXMID,YPMC00,JXMC00,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM, (select YBLBMC from BM_YBLB00 B WHERE A.YBLB00=B.YBLB00) YBLB, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,YPGG00,YPBM00,ybbrlb,TZBZ00,PYSM00,WBSM00,SCCJ00,YBBZ00,YBSCCJ,YPTYM0,YPMLBZ FROM VW_BM_YBSFDYYPMCFP A WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select ypnm00 from VW_BM_YPYBDY where rtrim(ltrim(lbbh00)) like ? and ltrim(rtrim(ylbh00)) like ? and rtrim(ltrim(jxbh00)) like ?) and sfybxm like ? and TZBZ00 like ? ORDER BY YPBM00 63 14:54:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 64 14:54:57 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 65 14:54:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 66 14:54:58 SQL Execute: ORACLE - select bmmc00 from BM_YPBM00 where ypnm00=? 67 14:54:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 68 14:54:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 69 14:54:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3268.000000 70 14:54:58 SQL Execute: ORACLE - SELECT a.fbbh00, a.SFXMID,a.SFYP00,a.YBZXLB,b.YBMC00 YBZXMC,a.YBXMBH,a.XMMC00,a.YBZYFP,a.ZYFPMC,a.YBMZFP,a.MZFPMC,a.ZFBL00,a.YBLB00,a.SFYBXM, (select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) YBLB, DECODE(a.SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,a.ybbrlb,a.SCCJ00,a.TZBZ00,a.YBBZ00,YBSCCJ FROM VW_BM_YBSFDYYPMCFP a,IC_YBBRLB b WHERE a.FBBH00=? AND a.YBZXLB<>? and a.sfxmid=? and a.FBBH00=b.FBBH00 and a.YBZXLB=b.YBLB00 and b.YBLB00=b.YBZXLB ORDER BY a.FBBH00,a.YBZXLB