1 16:52:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5862828 2 16:52:35 SQL Execute: ORACLE - select * from VW_PY_BRCFMX where CFLSH0 = ? order by CFID00 3 16:52:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = astar 4 16:52:35 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000 = ? 5 16:52:35 SQL Misc: ORACLE - Set stored procedure on or off 6 16:52:35 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 7 16:52:35 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5862828 8 16:52:35 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 9 16:52:35 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 10 16:52:35 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 11 16:52:35 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 12 16:52:35 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 13 16:52:35 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 16:52:35 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 16:52:35 SQL Data In: ORACLE - Param = 10, Name = PDKFYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 16 16:52:35 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PDKFYBZ => :PDKFYBZ); END; 17 16:52:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 285136 18 16:52:35 SQL Execute: ORACLE - select b.bmmc00,count(1) SL0000 from yf_mzcf00 a,bm_bmbm00 b where a.yfbmbh=b.bmbh00 and a.BRID00=? and a.CFZT00='1' and nvl(fyrq00,'20991231')='20991231' and a.jzrq00 >= to_char(sysdate-1,'YYYYMMDD') and a.CFZJE0>0 and not exists (select 1 from yf_mzcf00 where brid00=a.brid00 and jzrq00=a.jzrq00 and BCCFH0=a.cflsh0 and cfzje0<0) group by b.bmmc00 19 16:52:35 SQL Execute: ORACLE - commit 20 16:52:35 SQL Data In: ORACLE - Rows affected = 0 21 16:52:35 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20200301' and '20200324' and FYCKBH = 4 and ZT0000 = '2' order by JHXH00 desc ) A 22 16:52:35 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20200301' and '20200324' and FYCKBH = 4 and ZT0000 = '3' order by FYDLXH desc ) A 23 16:52:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5868667 24 16:52:36 SQL Execute: ORACLE - select * from VW_PY_BRCFMX where CFLSH0 = ? order by CFID00 25 16:52:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5862828 26 16:52:54 SQL Execute: ORACLE - select * from VW_PY_BRCFMX where CFLSH0 = ? order by CFID00 27 16:52:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = astar 28 16:52:54 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where XKH000 = ? 29 16:52:54 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20200301' and '20200324' and FYCKBH = 4 and ZT0000 = '3' order by FYDLXH desc ) A 30 16:52:54 SQL Misc: ORACLE - Set stored procedure on or off 31 16:52:54 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 32 16:52:54 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5862828 33 16:52:54 SQL Data In: ORACLE - Param = 3, Name = PFHRBH0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 34 16:52:54 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1913 35 16:52:54 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 36 16:52:54 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 37 16:52:54 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 16:52:54 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 16:52:54 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 40 16:52:54 SQL Data In: ORACLE - Param = 10, Name = PDKFYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 41 16:52:54 SQL Execute: ORACLE - BEGIN "SP_PY_MZPFYCZ" (POPFLAG => :POPFLAG,PCFLSH0 => :PCFLSH0,PFHRBH0 => :PFHRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PDKFYBZ => :PDKFYBZ); END; 42 16:52:54 SQL Execute: ORACLE - commit 43 16:52:54 SQL Data In: ORACLE - Rows affected = 0 44 16:52:54 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20200301' and '20200324' and FYCKBH = 4 and ZT0000 = '2' order by JHXH00 desc ) A 45 16:52:55 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20200301' and '20200324' and FYCKBH = 4 and ZT0000 = '3' order by FYDLXH desc ) A 46 16:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5868690 47 16:52:56 SQL Execute: ORACLE - select * from VW_PY_BRCFMX where CFLSH0 = ? order by CFID00