1       10:17:09  SQL Execute: ORACLE - select CFLSH0,SRRQ00,SRSJ00,ZWXM00,ZYTS00 from YS_CFXXB0 a,BM_YGBM00 b where a.YSGZH0=b.YGBH00(+) and a.BRID00=675229
 and ghh000<>'5245236' 
 and CFXZ00<>'0' and to_number(CFLSH0)<to_number('5198979') order by to_number(CFLSH0) desc

2       10:17:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 5097931         
3       10:17:09  SQL Execute: ORACLE - select a.YPNM00,a.YPZSL0,a.ypmc00,a.csl000 from YS_CFMX00  a,VW_YS_DMYPSR b where a.CFLSH0=?  and a.YPNM00=b.YPNM00 and b.YFBMBH=70 and b.CFJB00<=1   and b.GZDJ00<='1' and b.MZDJ00<='1' and b.DPDJ00<='1' and b.KSSDJ0<='0'  and ((b.SJDJ00>= '1' and '1'>'0') or b.SJDJ00='0' ) order by a.ZB0000,a.CFID00 

4       10:17:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2643
5       10:17:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70
6       10:17:09  SQL Execute: ORACLE - select * from yf_ypkcxx where ypnm00=? and yfbmbh=?

7       10:17:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2643
8       10:17:09  SQL Execute: ORACLE - SELECT zdxl00 FROM BM_YD0000 WHERE YPNM00=?

9       10:17:09  SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(2643,675229) VTS000 from dual 

10      10:17:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 5097931         
11      10:17:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 70
12      10:17:09  SQL Execute: ORACLE - select round(a.csl000*a.f2j000/b.f2j000,4) csl000,nvl(trim(b.mzkfdw),b.jldw00) jldw00,a.yysj00,a.yysjdw,a.zb0000,a.pslbid,a.sfzby0,a.zjyfid, a.ypzsl0,a.cfdw00,a.zhl000,a.sfxs00,a.zfbl00,a.yblb00,a.cxbz00,a.thbz00, a.yyzf00,a.xmyfmc,a.zxcs00,a.zqcs00, b.ypnm00,b.YPMC00,b.YPGG00,
Round(((b.lsj000/b.NSBL00)/b.K2J000)*DECODE('N','Y',c.F2J000,b.M2J000), 4) LSDJ00,
b.JLDW00,DECODE('N','Y',c.FYDW00,b.MZFYDW) AS MZFYDW,b.K2J000,DECODE('N','Y',c.F2J000,b.M2J000) AS M2J000,a.yfid00 yfid00,a.pcid00 pcid00 ,b.F2J000,,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00  from YS_CFMX00 a,BM_YD0000 b
,YF_YPKCXX c
 where a.CFLSH0=? and a.ypnm00+0=b.ypnm00 
 and a.ypnm00+0=c.ypnm00 and c.yfbmbh=? 
 and b.CFJB00<=1 and b.GZDJ00<='1' and b.MZDJ00<='1'   and b.DPDJ00<='1' and b.KSSJB0<='0' and ((b.SJDJ00>= '1' and '1'>'0')  or b.SJDJ00='0' ) 
order by a.ZB0000

13      10:17:09  SQL Error: ORACLE - ORA-00936: ȱʧ±í´ïʽ

14      10:17:09  SQL Error: ORACLE - Unmapped SQL Error Code: 936
15      10:17:09  SQL Data In: ORACLE - Rows affected = 0