1       08:27:53  SQL Execute: ORACLE - Delete from BM_ZHTJ00_TEMP00 where trim(Flag00)=trim('SUMZYRB0222')

2       08:27:53  SQL Data In: ORACLE - Rows affected = 0
3       08:27:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = SUMZYRB0222
4       08:27:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20101101
5       08:27:53  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20101101
6       08:27:53  SQL Execute: ORACLE - Insert into BM_ZHTJ00_TEMP00(flag00,STARTD,STOPDA,STARTT,STOPTI) values(?,?,?,'00:00:00','23:59:59')

7       08:27:53  SQL Data In: ORACLE - Rows affected = 1
8       08:27:53  SQL Execute: ORACLE - Commit

9       08:27:53  SQL Data In: ORACLE - Rows affected = 0
10      08:27:53  SQL Data In: ORACLE - Param = 1, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
11      08:27:53  SQL Data In: ORACLE - Param = 2, Name = Psfbhjz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
12      08:27:53  SQL Execute: ORACLE - BEGIN "SP_ZH_ZYRB00" (V_RETURN => :V_RETURN,Psfbhjz => :Psfbhjz); END;
13      08:27:54  SQL Execute: ORACLE - SELECT a.BMBH00,decode(a.BMBH00,-9999,'ȫԺ', (select BMMC00 from BM_BMBM00 where BMBH00=a.BMBH00)) BMMC00, a.SFXM15, (select BMMC00 from BM_BMBM00 where BMBH00=a.SFXM15) KSMC00, decode(a.sjysxm,'!',' ',a.sjysxm) sjysxm, SFXM01 RYRS00,SFXM02 CYRS00,SFXM03 ZRRS00,SFXM04 ZCRS00,SFXM05 ZYRS00,SFXM06 HJFJE0, SFXM07 YLFJE0,SFXM08 YPFJE0,TRIM(TO_CHAR(SFXM09,'9990.00'))||'%' SFXM09,SFXM10, SFXM12,SFXM13,decode(SFXM02,0,null,round(SFXM12/SFXM02,2)) PJZYTS from BM_YYSFTJ a,BM_BMBM00 b where a.bmbh00=b.bmbh00(+) and ID0000=1396500 and sfxm16 in(0,1) order by nvl(b.pxxh00,decode(a.bmbh00,-9999,-9999,9999,9999,8888)),a.bmbh00