1       10:21:28  SQL Prepare: ORACLE - select * from bm_yplb00 order by lbbh00

2       10:21:28  SQL Execute: ORACLE - select * from bm_yplb00 order by lbbh00

3       10:21:28  SQL Prepare: ORACLE - select * from bm_ypyl00 where rtrim(ltrim(lbbh00))=:1 order by ylbh00

4       10:21:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
5       10:21:28  SQL Execute: ORACLE - select * from bm_ypyl00 where rtrim(ltrim(lbbh00))=? order by ylbh00

6       10:21:28  SQL Prepare: ORACLE - select * from bm_ypjx00 where rtrim(ltrim(lbbh00))=:1 order by jxbh00

7       10:21:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
8       10:21:28  SQL Execute: ORACLE - select * from bm_ypjx00 where rtrim(ltrim(lbbh00))=? order by jxbh00

9       10:21:28  SQL Prepare: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3

10      10:21:28  SQL Execute: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3

11      10:21:28  SQL Prepare: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw
from ic_ybbrlb where yblb00=ybzxlb and  yblb00<>'0' and fbbh00=:1

12      10:21:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
13      10:21:28  SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw
from ic_ybbrlb where yblb00=ybzxlb and  yblb00<>'0' and fbbh00=?

14      10:21:28  SQL Prepare: 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,YBSCCJ
FROM VW_BM_YBSFDYYPMCFP A
WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select ypnm00 from VW_BM_YPYBDY where rtrim(ltrim(lbbh00)) like :3 and ltrim(rtrim(ylbh00)) like :4 and rtrim(ltrim(jxbh00)) like :5)
and sfybxm like :6 and TZBZ00 like :7
ORDER BY YPBM00

15      10:21:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
16      10:21:28  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
17      10:21:28  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
18      10:21:28  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
19      10:21:28  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
20      10:21:28  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
21      10:21:28  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
22      10:21:28  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,YBSCCJ
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

23      10:21:28  SQL Error: ORACLE - ORA-01427: 单行子查询返回多于一个行

24      10:21:28  SQL Error: ORACLE - Unmapped SQL Error Code: 1427
25      10:21:28  SQL Data In: ORACLE - Rows affected = 0