1       15:22:40  SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1


2       15:22:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
3       15:22:40  SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=?


4       15:22:43  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

5       15:22:43  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

6       15:22:43  SQL Prepare: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like :1 or WPBH00 Like :2) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

7       15:22:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
8       15:22:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %%
9       15:22:43  SQL Execute: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

10      15:22:45  SQL Prepare: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like :1) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

11      15:22:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %m%
12      15:22:45  SQL Execute: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like ?) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

13      15:22:45  SQL Prepare: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like :1) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

14      15:22:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %mh%
15      15:22:45  SQL Execute: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like ?) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

16      15:22:46  SQL Prepare: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like :1) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

17      15:22:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %mhq%
18      15:22:46  SQL Execute: ORACLE - select WPMC00,PYSM00,WBSM00,WPDJ00,WPGG00,WPDW00,WPBH00,DQKCL0 from vw_gy_wpbm00 where (PYSM00 Like ?) and( wpxz00<>0 AND GYKSBH=62 )  and Rownum<=200

19      15:22:53  SQL Prepare: ORACLE - select SQ_GY_WPTK00_TKJLID.nextval from dual

20      15:22:53  SQL Execute: ORACLE - select SQ_GY_WPTK00_TKJLID.nextval from dual

21      15:22:53  SQL Prepare: ORACLE - insert into GY_WPTK00(TKJLID,TKRBH0,TKRQ00,TKKSBH,TKZT00) values('5','157','20100115','62',0)

22      15:22:53  SQL Execute: ORACLE - insert into GY_WPTK00(TKJLID,TKRBH0,TKRQ00,TKKSBH,TKZT00) values('5','157','20100115','62',0)

23      15:22:53  SQL Data In: ORACLE - Rows affected = 1
24      15:22:53  SQL Prepare: ORACLE - insert into GY_WPTKMX
  (ID0000, TKJLID, WPBH00, TKSL00, TKYY00)
values
  (SQ_GY_WPTKMX_ID0000.NextVal, :1, :2, :3, :4)

25      15:22:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
26      15:22:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2903
27      15:22:53  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
28      15:22:53  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
29      15:22:53  SQL Execute: ORACLE - insert into GY_WPTKMX
  (ID0000, TKJLID, WPBH00, TKSL00, TKYY00)
values
  (SQ_GY_WPTKMX_ID0000.NextVal, ?, ?, ?, ?)

30      15:22:53  SQL Data In: ORACLE - Rows affected = 1
31      15:22:53  SQL Prepare: ORACLE - Commit

32      15:22:53  SQL Execute: ORACLE - Commit

33      15:22:53  SQL Data In: ORACLE - Rows affected = 0
34      15:22:53  SQL Prepare: ORACLE - select a.*,b.zwxm00 from gy_wptk00 a,bm_ygbm00 b
where a.tkrbh0=b.ygbh00 and 
tkrq00 between :1 and :2 AND TKKSBH=:3
AND TKZT00=0

35      15:22:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115
36      15:22:53  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115
37      15:22:53  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 62
38      15:22:53  SQL Execute: ORACLE - select a.*,b.zwxm00 from gy_wptk00 a,bm_ygbm00 b
where a.tkrbh0=b.ygbh00 and 
tkrq00 between ? and ? AND TKKSBH=?
AND TKZT00=0

39      15:22:53  SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1


40      15:22:53  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
41      15:22:53  SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=?