1 15:23:54 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 2 15:23:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115 3 15:23:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115 4 15:23:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 62 5 15:23:54 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 6 15:23:54 SQL Prepare: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 7 15:23:54 SQL Data In: ORACLE - Param = 1, Name = I_TKJLID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 8 15:23:54 SQL Data In: ORACLE - Param = 2, Name = I_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000 9 15:23:54 SQL Execute: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 10 15:23:54 SQL Prepare: ORACLE - Commit 11 15:23:54 SQL Execute: ORACLE - Commit 12 15:23:54 SQL Data In: ORACLE - Rows affected = 0 13 15:23:54 SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1 14 15:23:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 15 15:23:54 SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=? 16 15:23:54 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 17 15:23:54 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 18 15:23:56 SQL Prepare: ORACLE - select FYBZ00,BMXZ00 from BM_BMBM00 where BMBH00=62 19 15:23:56 SQL Execute: ORACLE - select FYBZ00,BMXZ00 from BM_BMBM00 where BMBH00=62 20 15:23:56 SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1 21 15:23:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 22 15:23:56 SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=? 23 15:23:56 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 24 15:23:56 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 25 15:23:57 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 26 15:23:57 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 27 15:23:57 SQL Prepare: ORACLE - Update GY_WPTK00 SET TKZT00='1' Where TKJLID=5 28 15:23:57 SQL Execute: ORACLE - Update GY_WPTK00 SET TKZT00='1' Where TKJLID=5 29 15:23:57 SQL Data In: ORACLE - Rows affected = 1 30 15:23:57 SQL Prepare: ORACLE - Commit 31 15:23:57 SQL Execute: ORACLE - Commit 32 15:23:57 SQL Data In: ORACLE - Rows affected = 0 33 15:23:57 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 34 15:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115 35 15:23:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100115 36 15:23:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 62 37 15:23:57 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 38 15:23:57 SQL Prepare: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 39 15:23:57 SQL Data In: ORACLE - Param = 1, Name = I_TKJLID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 40 15:23:57 SQL Data In: ORACLE - Param = 2, Name = I_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000 41 15:23:57 SQL Execute: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 42 15:23:57 SQL Prepare: ORACLE - Commit 43 15:23:57 SQL Execute: ORACLE - Commit 44 15:23:57 SQL Data In: ORACLE - Rows affected = 0 45 15:23:57 SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1 46 15:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 47 15:23:57 SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=? 48 15:23:57 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 49 15:23:57 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=5 AND WPBH00='2903' 50 15:23:57 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903' 51 15:23:57 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903' 52 15:23:57 SQL Prepare: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 53 15:23:57 SQL Data In: ORACLE - Param = 1, Name = I_TKJLID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 54 15:23:57 SQL Data In: ORACLE - Param = 2, Name = I_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000 55 15:23:57 SQL Execute: ORACLE - BEGIN "P_GY_SCTKPCMXSJ" (I_TKJLID => :I_TKJLID,I_KSBH00 => :I_KSBH00); END; 56 15:23:57 SQL Prepare: ORACLE - Commit 57 15:23:57 SQL Execute: ORACLE - Commit 58 15:23:57 SQL Data In: ORACLE - Rows affected = 0 59 15:23:57 SQL Prepare: ORACLE - select * from vw_gy_wptkmx where TKJLID=:1 60 15:23:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 61 15:23:57 SQL Execute: ORACLE - select * from vw_gy_wptkmx where TKJLID=? 62 15:23:57 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903' 63 15:23:57 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903' 64 15:23:57 SQL Prepare: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903' 65 15:23:57 SQL Execute: ORACLE - SELECT * FROM VW_GY_WPTKPCMX WHERE TKJLID=3 AND WPBH00='2903'