1836 11:43:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000026556 1837 11:43:33 SQL Execute: ORACLE - SELECT 'Y' sfxz00, b.ybmc00, a.fbbh00, a.sfxmid, a.sfyp00, a.ybzxlb, a.ybxmbh, a.ybxmmc xmmc00, a.zfbl00, a.zyzfbl, a.yblb00, a.sfybxm, a.zyfpxm zyfpmc, a.mzfpxm mzfpmc, DECODE (a.yblb00, '0', '医保项目', '1', '部分医保', '2', '非医保', '3', '非医保', '非医保' ) yblb, DECODE (a.sfybxm, 'Y', '医保项目', 'N', '非医保项目') sfxm00, a.ybbrlb, a.tzbz00, a.pysm00 ybpysm, a.wbsm00 ybwbsm, a.ybmzfp, a.ybzyfp, a.xgrxm0, a.xgrqsj, 0 xgbz00, '' YBSCCJ,'' YBBZ00 FROM vw_bm_ybsfdyxmmcfp a, ic_ybbrlb b WHERE a.sfxmid = ? AND a.sfyp00 = 'N' AND a.ybzxlb = b.ybzxlb AND b.yblb00 = b.ybzxlb ORDER BY DECODE (a.fbbh00, 3, 0, a.fbbh00), b.ybmc00 1838 11:43:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000026556 1839 11:43:33 SQL Execute: ORACLE - SELECT 'Y' sfxz00, b.ybmc00, a.fbbh00, a.sfxmid, a.sfyp00, a.ybzxlb, a.ybxmbh, a.ybxmmc xmmc00, a.zfbl00, a.zyzfbl, a.yblb00, a.sfybxm, a.zyfpxm zyfpmc, a.mzfpxm mzfpmc, DECODE (a.yblb00, '0', '医保项目', '1', '部分医保', '2', '非医保', '3', '非医保', '非医保' ) yblb, DECODE (a.sfybxm, 'Y', '医保项目', 'N', '非医保项目') sfxm00, a.ybbrlb, a.tzbz00, a.pysm00 ybpysm, a.wbsm00 ybwbsm, a.ybmzfp, a.ybzyfp, a.xgrxm0, a.xgrqsj, 0 xgbz00, '' YBSCCJ,'' YBBZ00 FROM vw_bm_ybsfdyxmmcfp a, ic_ybbrlb b WHERE a.sfxmid = ? AND a.sfyp00 = 'N' AND a.ybzxlb = b.ybzxlb AND b.yblb00 = b.ybzxlb ORDER BY DECODE (a.fbbh00, 3, 0, a.fbbh00), b.ybmc00 1840 11:43:39 SQL Execute: ORACLE - select c.YPMC00,b.XMMC00||'['||b.BH0000||']' as XMMCBH from VW_WZ_FJSFXM a,BM_YYSFXM b,BM_YD0000 c where a.YPNM00=7000000355 and a.SFXMID=b.SFXMID and a.YPNM00=c.YPNM00 and a.sfxmid= 1841 11:43:39 SQL Error: ORACLE - ORA-00936: 缺失表达式 1842 11:43:39 SQL Error: ORACLE - Unmapped SQL Error Code: 936 1843 11:43:39 SQL Data In: ORACLE - Rows affected = 0 1844 11:45:56 SQL Execute: ORACLE - select c.YPMC00,b.XMMC00||'['||b.BH0000||']' as XMMCBH from VW_WZ_FJSFXM a,BM_YYSFXM b,BM_YD0000 c where a.YPNM00=7000000355 and a.SFXMID=b.SFXMID and a.YPNM00=c.YPNM00 and a.sfxmid= 1845 11:45:56 SQL Error: ORACLE - ORA-00936: 缺失表达式 1846 11:45:56 SQL Error: ORACLE - Unmapped SQL Error Code: 936 1847 11:45:56 SQL Data In: ORACLE - Rows affected = 0