1 17:53:09 SQL Prepare: ORACLE - SELECT A.*,B.YPTYM0 FROM YK_YPQLMX A,BM_YD0000 B WHERE YPQLDH='' AND A.YPNM00=B.YPNM00 2 17:53:09 SQL Execute: ORACLE - SELECT A.*,B.YPTYM0 FROM YK_YPQLMX A,BM_YD0000 B WHERE YPQLDH='' AND A.YPNM00=B.YPNM00 3 17:53:16 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 4 17:53:16 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 5 17:53:16 SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like :1) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 6 17:53:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = b% 7 17:53:16 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like ?) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 8 17:53:16 SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like :1 or BH0000 Like :2) and( BMXZ00<>'6' ) order by BH0000,PYSM00) where Rownum<=10 9 17:53:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 10 17:53:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 11 17:53:16 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like ? or BH0000 Like ?) and( BMXZ00<>'6' ) order by BH0000,PYSM00) where Rownum<=10 12 17:53:18 SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like :1) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 13 17:53:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = w% 14 17:53:18 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like ?) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 15 17:53:18 SQL Prepare: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like :1) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 16 17:53:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = wg% 17 17:53:18 SQL Execute: ORACLE - Select * from (select BMMC00,BH0000,WBSM00,PYSM00,BMBH00 from VW_YK_YPCKFX where (PYSM00 Like ?) and( BMXZ00<>'6' ) order by PYSM00) where Rownum<=10 18 17:53:19 SQL Prepare: ORACLE - select YGBH00,ZWXM00 from BM_YGBM00 where BMBH00='17' AND CZBZ00<>'2' 19 17:53:19 SQL Execute: ORACLE - select YGBH00,ZWXM00 from BM_YGBM00 where BMBH00='17' AND CZBZ00<>'2' 20 17:53:23 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like :1) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 21 17:53:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = s% 22 17:53:23 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like ?) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 23 17:53:24 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like :1) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 24 17:53:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = sy% 25 17:53:24 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like ?) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 26 17:53:24 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like :1) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 27 17:53:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = sys% 28 17:53:24 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KC0000,PFJ000,SPM000,SCCJZW,YPTYM0 from VW_YK_YPSRTS where (PYSM00 Like ?) and( YKBMBH=143 ) order by PYSM00) where Rownum<=10 29 17:53:27 SQL Prepare: ORACLE - SELECT NVL(KCSL00,0)-1 KCSL00 FROM VW_YK_YPKCXX WHERE YPNM00=1302159 AND YKBMBH=143 30 17:53:27 SQL Execute: ORACLE - SELECT NVL(KCSL00,0)-1 KCSL00 FROM VW_YK_YPKCXX WHERE YPNM00=1302159 AND YKBMBH=143 31 17:53:27 SQL Prepare: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 32 17:53:27 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 17:53:27 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 8, Scale = 0, Data = YKYPQLDH 34 17:53:27 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 35 17:53:27 SQL Prepare: ORACLE - INSERT INTO YK_YPQLD0 (YPQLDH,YKBMBH,CKQXBH,CZYBH0,LYRBH0,QLZT00,CKLXBH,QLRQ00,QLSJ00) VALUES(:1,:2,:3,:4,:5,:6, '05',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 36 17:53:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 007049 37 17:53:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 143.000000 38 17:53:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 17 39 17:53:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3130.000000 40 17:53:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 818 41 17:53:27 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 42 17:53:27 SQL Execute: ORACLE - INSERT INTO YK_YPQLD0 (YPQLDH,YKBMBH,CKQXBH,CZYBH0,LYRBH0,QLZT00,CKLXBH,QLRQ00,QLSJ00) VALUES(?,?,?,?,?,?, '05',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 43 17:53:27 SQL Data In: ORACLE - Rows affected = 0 44 17:53:27 SQL Prepare: ORACLE - ROLLBACK WORK 45 17:53:27 SQL Execute: ORACLE - ROLLBACK WORK