1 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 2 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 3 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 4 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 5 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 6 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 7 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 8 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 9 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 10 11:21:23 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 11 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 12 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 13 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 14 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 15 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 16 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 17 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 18 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 19 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 20 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 21 11:21:24 SQL Execute: ORACLE - Select SYSDATE from Dual 22 11:21:24 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 23 11:21:24 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 24 11:21:24 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0222142600580078' and ICKNBH ='0222142600580078' 25 11:21:24 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =1095913 26 11:21:24 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_MZ' 27 11:21:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 28 11:21:24 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 29 11:21:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1460.000000 30 11:21:24 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 31 11:21:24 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000 32 11:21:24 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 33 11:21:24 SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222142600580078 34 11:21:24 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1460.000000 35 11:21:24 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 李碧州 36 11:21:24 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 37 11:21:24 SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 11:21:24 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 39 11:21:24 SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 11:21:24 SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 11:21:24 SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 11:21:24 SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 11:21:24 SQL Execute: ORACLE - BEGIN "SP_ONEPAY_YJJPTJK" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PCARDNO => :PCARDNO,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PRECODE => :PRECODE,PERRMSG => :PERRMSG); END; 44 11:21:24 SQL Execute: ORACLE - Rollback 45 11:21:24 SQL Data In: ORACLE - Rows affected = 0 46 11:21:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222142600580078 47 11:21:24 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 48 11:21:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222142600580078 49 11:21:24 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 50 11:21:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222142600580078 51 11:21:24 SQL Execute: ORACLE - select brid00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 52 11:21:24 SQL Execute: ORACLE - select * from ( select * from VW_SF_BRGH00 A where SFYY00 = 'N' and THRQ00 is null and BRID00 = 1095913 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD' ) and GHRQ00 >= '20190201' and GHRQ00 <= '20190318' ) order by ghh000 desc 53 11:21:24 SQL Execute: ORACLE - select ICKH00 from ic_yhxx00 where brid00 = 1095913 and ZT0000 = '1' 54 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 55 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 56 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 57 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 58 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 59 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 60 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 61 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 62 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 63 11:21:24 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 64 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 65 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 66 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 67 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 68 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 69 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 70 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 71 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 72 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069' 73 11:21:26 SQL Execute: ORACLE - select * from vw_sf_wjzcf where BRID00='1095913' AND GHH000='3600069'