1 11:23:33 SQL Prepare: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=305 2 11:23:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=305 3 11:23:33 SQL Prepare: ORACLE - delete from YF_YPCKMX_TEMP 4 11:23:33 SQL Execute: ORACLE - delete from YF_YPCKMX_TEMP 5 11:23:33 SQL Data In: ORACLE - Rows affected = 16 6 11:23:33 SQL Prepare: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,GJDJ00) VALUES(:1,:2,:3,:4,:5) 7 11:23:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 50246 8 11:23:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.24 9 11:23:33 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 10 11:23:33 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 11 11:23:33 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.17 12 11:23:33 SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,GJDJ00) VALUES(?,?,?,?,?) 13 11:23:33 SQL Data In: ORACLE - Rows affected = 1 14 11:23:33 SQL Prepare: ORACLE - commit 15 11:23:33 SQL Execute: ORACLE - commit 16 11:23:33 SQL Data In: ORACLE - Rows affected = 0 17 11:23:35 SQL Prepare: ORACLE - Select * from (select YPMC00,LSDJ00,SCPH00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,PFDJ00,ZHL000 from VW_YF_YPTKPHTS where (SCPH00 Like :1) and( YKBMBH=11 and YPNM00=50246 and YFBMBH=305 ) Order By SCPH00) where Rownum<=150 18 11:23:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 2% 19 11:23:35 SQL Execute: ORACLE - Select * from (select YPMC00,LSDJ00,SCPH00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,PFDJ00,ZHL000 from VW_YF_YPTKPHTS where (SCPH00 Like ?) and( YKBMBH=11 and YPNM00=50246 and YFBMBH=305 ) Order By SCPH00) where Rownum<=150 20 11:23:36 SQL Prepare: ORACLE - Select * from (select YPMC00,LSDJ00,SCPH00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,PFDJ00,ZHL000 from VW_YF_YPTKPHTS where (SCPH00 Like :1) and( YKBMBH=11 and YPNM00=50246 and YFBMBH=305 ) Order By SCPH00) where Rownum<=150 21 11:23:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 22 11:23:36 SQL Execute: ORACLE - Select * from (select YPMC00,LSDJ00,SCPH00,YPSXRQ,YPRKPC,SCCJBH,SCCJZW,YPQLDH,GJDJ00,CKSL00,PFDJ00,ZHL000 from VW_YF_YPTKPHTS where (SCPH00 Like ?) and( YKBMBH=11 and YPNM00=50246 and YFBMBH=305 ) Order By SCPH00) where Rownum<=150 23 11:23:41 SQL Prepare: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=305 24 11:23:41 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=305 25 11:23:41 SQL Prepare: ORACLE - delete from YF_YPCKMX_TEMP 26 11:23:41 SQL Execute: ORACLE - delete from YF_YPCKMX_TEMP 27 11:23:41 SQL Data In: ORACLE - Rows affected = 1 28 11:23:41 SQL Prepare: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,GJDJ00) VALUES(:1,:2,:3,:4,:5) 29 11:23:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 50246 30 11:23:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.24 31 11:23:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 32 11:23:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 33 11:23:41 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0.17 34 11:23:41 SQL Execute: ORACLE - insert into YF_YPCKMX_TEMP(YPNM00,LSDJ00,CKSL00,ZHL000,GJDJ00) VALUES(?,?,?,?,?) 35 11:23:41 SQL Data In: ORACLE - Rows affected = 1 36 11:23:41 SQL Prepare: ORACLE - commit 37 11:23:41 SQL Execute: ORACLE - commit 38 11:23:41 SQL Data In: ORACLE - Rows affected = 0 39 11:23:41 SQL Prepare: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 40 11:23:41 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 11:23:41 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = YKRKDH 42 11:23:41 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 43 11:23:41 SQL Prepare: ORACLE - INSERT INTO YK_YPRKD0 (RKDH00,YKBMBH,CZYBH0,GHDWNM,RKLXBH,JHRQ00,JHSJ00,TKRY00) VALUES(:1,:2,:3,:4,:5, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),:6) 44 11:23:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 215486 45 11:23:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 46 11:23:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1372.000000 47 11:23:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 305.000000 48 11:23:41 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 06 49 11:23:41 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 50 11:23:41 SQL Execute: ORACLE - INSERT INTO YK_YPRKD0 (RKDH00,YKBMBH,CZYBH0,GHDWNM,RKLXBH,JHRQ00,JHSJ00,TKRY00) VALUES(?,?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),?) 51 11:23:41 SQL Data In: ORACLE - Rows affected = 1 52 11:23:41 SQL Prepare: ORACLE - insert into YK_YPRKMX (YPRKPC, RKDH00, FPH000, FPFLH0, YPNM00, YPMC00, YPGG00, RKDW00, ZHL000, RKSL00, FPGJDJ, KL0000, LSDJ00, PFDJ00, GJJE00, PCKCSL, SCPH00, YPSXRQ, XXLSDJ, YPTHPC, CXRKPC, SCCJBH, SCCJZW, CFWZBH, CFWZMC, BZ0000, SFZBYP,PZWH00) values (SQ_YK_YPRKMX_YPRKPC.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26,:27) 53 11:23:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 215486 54 11:23:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 55 11:23:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 11:23:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50246.000000 57 11:23:41 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0.9%ÂÈ»¯ÄÆ×¢ÉäÒº 58 11:23:41 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 10ml:90mg 59 11:23:41 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Ö§ 60 11:23:41 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 61 11:23:41 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 62 11:23:41 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.170000 63 11:23:41 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 64 11:23:41 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.240000 65 11:23:41 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.170000 66 11:23:41 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.170000 67 11:23:41 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 11:23:41 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 123 69 11:23:41 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 70 11:23:41 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.240000 71 11:23:41 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 72 11:23:41 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 73 11:23:41 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 74 11:23:41 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 75 11:23:41 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 76 11:23:41 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 77 11:23:41 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 78 11:23:41 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 79 11:23:41 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H20103054 80 11:23:41 SQL Execute: ORACLE - insert into YK_YPRKMX (YPRKPC, RKDH00, FPH000, FPFLH0, YPNM00, YPMC00, YPGG00, RKDW00, ZHL000, RKSL00, FPGJDJ, KL0000, LSDJ00, PFDJ00, GJJE00, PCKCSL, SCPH00, YPSXRQ, XXLSDJ, YPTHPC, CXRKPC, SCCJBH, SCCJZW, CFWZBH, CFWZMC, BZ0000, SFZBYP,PZWH00) values (SQ_YK_YPRKMX_YPRKPC.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?) 81 11:23:41 SQL Data In: ORACLE - Rows affected = 1 82 11:23:45 SQL Prepare: ORACLE - SELECT R.RKLXBH,R.GHDWNM,G.BMMC00 as GHDWMC,R.JHRQ00,R.TKRY00,(SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=R.TKRY00) tkryxm FROM YK_YPRKD0 R,VW_YK_YPCKFX G WHERE R.GHDWNM=G.BMBH00 AND R.RKZT00='0' AND R.YKBMBH=11 AND R.RKDH00='215486' AND R.RKLXBH='06' 83 11:23:45 SQL Execute: ORACLE - SELECT R.RKLXBH,R.GHDWNM,G.BMMC00 as GHDWMC,R.JHRQ00,R.TKRY00,(SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=R.TKRY00) tkryxm FROM YK_YPRKD0 R,VW_YK_YPCKFX G WHERE R.GHDWNM=G.BMBH00 AND R.RKZT00='0' AND R.YKBMBH=11 AND R.RKDH00='215486' AND R.RKLXBH='06' 84 11:23:45 SQL Prepare: ORACLE - SELECT x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz FROM YK_YPRKMX x WHERE x.RKDH00='215486' 85 11:23:45 SQL Execute: ORACLE - SELECT x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz FROM YK_YPRKMX x WHERE x.RKDH00='215486'