1       17:03:06  SQL Execute: ORACLE - lock table BM_YD0000 in exclusive mode nowait 

2       17:03:06  SQL Data In: ORACLE - Rows affected = 0
3       17:03:10  SQL Execute: ORACLE - SELECT MRJCL0 FROM BM_YPLB00 WHERE LBBH00=

4       17:03:10  SQL Error: ORACLE - ORA-00921: 未预期的 SQL 命令结尾

5       17:03:10  SQL Error: ORACLE - Unmapped SQL Error Code: 921
6       17:03:10  SQL Data In: ORACLE - Rows affected = 0
7       17:03:11  SQL Execute: ORACLE - commit

8       17:03:11  SQL Data In: ORACLE - Rows affected = 0
9       17:03:11  SQL Execute: ORACLE - select C.*,FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,
MZFPMC,B.ZFBL00,B.YBLB00,SFYBXM,YBLB,SFXM00,YBBRLB,TZBZ00,JXMC00,YBPYSM,YBWBSM,
(SELECT YLMC00 from BM_YPYL00 WHERE LBBH00=C.LBBH00 AND YLBH00=C.YLBH00) L_YPYL,
(SELECT JXMC00 from BM_YPJX00 WHERE LBBH00=C.LBBH00 AND JXBH00=C.JXBH00) L_YPJX, 
 substr(SF_YK_GetYBYLMC(C.YBYLID),1,120) YBYLMC, 0 YBYLXG 
,substr(SF_YK_GetLJYPFL(C.YPNM00),1,120) LJYPFL 
,substr(SF_YK_GetTSSXMC(C.YPNM00),1,120) TSSXMC 
 FROM (select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW, 
 substr(SF_YK_GetYBYLID(a.YPNM00),1,100) YBYLID, 
 (select GHDWMC from BM_YPGHDW where GHDWNM=A.GHDWNM and rownum=1) GHDWMC
 from bm_yd0000 A,BM_CJYLBM B where 1=1 and A.CYLLSH=B.LSH000(+)
 and A.LBBH00 like '%'
 and A.YLBH00 like '%'
 and A.JXBH00 like '%'
 and A.YKBMBH=72
 and A.TZRQ00 IS NULL
 ) C,
(select FBBH00,SFXMID,SFYP00,YBZXLB,YBXMBH,XMMC00,YBZYFP,ZYFPMC,YBMZFP,MZFPMC,ZFBL00,YBLB00,SFYBXM,JXMC00,
DECODE(YBLB00,'4','甲类药品','5','乙类药品','6','民族药品','7','非医保药品','8','医保药品') YBLB,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目') SFXM00,YBBRLB,TZBZ00,PYSM00 YBPYSM,WBSM00 YBWBSM 
 from  VW_BM_YBSFDYYPMCFP where 1=1 
 and FBBH00='0'
 and YBZXLB=''
 and SFYBXM like '%'
 AND TZBZ00 like '%'
 ) B  where C.YPNM00=B.SFXMID(+) 
 order by C.YPBM00

10      17:03:12  SQL Execute: ORACLE - select count(1) count0 from bm_yd0000
 where LBBH00 like '%'
 and YLBH00 like '%'
 and JXBH00 like '%'
 and YKBMBH=72
 and TZRQ00 IS NULL
 order by YPBM00 

11      17:03:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
12      17:03:12  SQL Execute: ORACLE - select * from BM_YPJX00
where lbbh00=?

13      17:03:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
14      17:03:12  SQL Execute: ORACLE - select * from BM_YPYL00
where lbbh00=?