1 15:31:57 SQL Execute: ORACLE - Select SYSDATE from Dual 2 15:31:57 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 15:31:57 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') 4 15:31:57 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0227769100484745' and ICKNBH = '0227769100484745' 5 15:31:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 6 15:31:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227769100484745 7 15:31:57 SQL Execute: ORACLE - select a.* from VW_SF_BRZHXX a where a.SFDJ00<>'2' and a.JFLBID = ? and a.ICKH00 = ? 8 15:31:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 9 15:31:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 10 15:31:58 SQL Execute: ORACLE - select E.CSLX00,A.KHRQ00,A.XJYE00,A.ZZYE00,A.YXQFJE,A.TYJE00,SF_SF_GETKYJE(A.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,B.JFLBMC,D.FBMC00,e.YBMC00, C.BRCSRQ,C.FBBH00,C.BRZJBH,C.BRBLH0,C.BRXM00,C.BRXB00,C.YBKH00,C.YBID00,C.YBLB00,C.YBBRLB,C.BRZTQK from SF_BRZHXX A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D,ic_ybbrlb E where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and C.fbbh00=E.fbbh00 and C.yblb00=E.yblb00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 11 15:31:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 12 15:31:58 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 13 15:31:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 14 15:31:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210128 15 15:31:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210203 16 15:31:59 SQL Execute: ORACLE - select CFLSH0 from YF_MZCF00 where BRID00=? and CFZT00 = '0' and SRRQ00>= ? and SRRQ00<= ? 17 15:32:08 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 18 15:32:08 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 193.000000 19 15:32:08 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1395998.000000 20 15:32:08 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 21 15:32:08 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 857 and CZXH00 = 1395998.00) 22 15:32:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 23 15:32:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 24 15:32:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20050401 25 15:32:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210203 26 15:32:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000001328.000000 27 15:32:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 28 15:32:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 29 15:32:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210128 30 15:32:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210203 31 15:32:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 32 15:32:58 SQL Execute: ORACLE - select * from ( select a.GHH000,a.FPXMMC,a.XMMC00,a.XMDJ00,a.XMDW00,a.XMSL00,a.HJJE00,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.KDYSXM,a.DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.MZFPID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(a.YJDJH0) as YJDJH0,a.SFLB00,a.MXID00,a.CXBZ00,a.OMXID0,a.CFDGS0,a.ZXKSMC, a.CZRQ00,a.JZZTMC,a.TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_WJSFYMX a where a.BRID00 = ? and a.JFLBID = ? and a.CZRQ00>= ? and a.CZRQ00<= ? and a.XMBH00+0 <> ? union all select a.GHH000,a.FPXMMC,a.SFXMMC,a.XMDJ00,a.XMDW00,a.XMSL00,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.BMMC00 KDKSMC,a.KDYSXM,0 DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(A.YJDJH0),a.JSXM00 SFLB00,a.ID0000 MXID00,'Z',0,a.CFDGS0,a.YJKSMC, a.KDRQ00,a.JZZTMC,'' as TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_YJYWMX a where a.CXDJH0 is null and A.BRID00 = ? union all select a.GHH000,a.FPXMMC,a.YPMC00,a.LSDJ00,a.CFDW00,a.YPZSL0,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.YSXM00,0 DJH000,a.TSBZBH,a.TSBZMC,FPXMMC ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,a.CFLSH0,a.SFLB00,CFID00 MXID00,'Z',0,a.CFDGS0,a.BMMC00, a.SRRQ00,a.JZZTMC,'' as TCNWJC,0 as TCID00,null as TCXMMC from VW_SF_CFMX00 a where a.BCCFH0 is null and a.THBZ00='0' and a.BRID00 = ? and a.SRRQ00>= ? and a.SRRQ00<= ? and a.SRRQ00>= to_char(sysdate-?,'YYYYMMDD') ) order by GHH000,JZBZ00,MZFPID,CFDGS0,YJDJH0,MXID00,ZLXMJC 33 15:32:58 SQL Execute: ORACLE - select a.GHH000,substr(SF_SF_GETRQSJ(A.GHRQ00,A.GHSJ00),1,50) GHRQSJ,a.GHRQ00,b.bmmc00 GHKSMC, nvl((select YBBMMC from BM_YBKSBM where YBBMBH=b.YBKSBH and rownum=1),b.BMMC00) as YBGHKS, (select zwxm00 from BM_YGBM00 where ygbh00=a.jzys00) JZYSXM,a.GHYXM0,a.YBGHH0, (select mc0000 from VW_SF_TSBZB0 where BH0000=a.TSBZBH and YBZXLB=a.YBZXLB) TSBZMC, a.TSBZBH,a.GHKS00, (select LBMC00 from BM_GHLBB0 where LBBH00=a.GHLB00) GHLBMC,a.GHSJ00,a.BXLB00,a.GHID00, (select nvl(min(JZRQ00),a.GHRQ00) from SF_JZB000 where MZID00=a.GHID00 and HJJE00>0 and nvl(YBGHH0,'0')<>'0' and YBGHH0=a.YBGHH0) YBJZRQ,0 BCSFCS, decode((select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1),'',(select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='1' and rownum=1), (select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1)) as ZDMC00 from sf_brxxb0 a,BM_BMBM00 b where a.GHH000 in ('13336631','13405091') and a.GHKS00=b.bmbh00 order by a.GHID00 34 15:32:58 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(857,193) as PJXH00 from dual 35 15:32:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 36 15:32:58 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 37 15:33:10 SQL Execute: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00 = '事前审方-事前审方系统' and BZ0000 = '是否启用审方系统' 38 15:33:10 SQL Execute: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00 = '事前审方-事前审方系统' and BZ0000 = '是否启用审方系统' 39 15:33:10 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(857,193) as PJXH00 from dual 40 15:33:10 SQL Execute: ORACLE - select count(0) num from SF_YBZFJD where BRID00=139317 and YXBZ00='1' 41 15:33:12 SQL Execute: ORACLE - Select SYSDATE from Dual 42 15:33:12 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 43 15:33:12 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') 44 15:33:12 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0227769100484745' and ICKNBH = '0227769100484745' 45 15:33:12 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDDHH24:MI:SS') OraSysDate FROM DUAL 46 15:33:12 SQL Execute: ORACLE - Select SQ_SF_JZB000_JZDH00.NextVal Val from Dual 47 15:33:12 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 33302098 48 15:33:12 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 49 15:33:12 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2786116.000000 50 15:33:12 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 51 15:33:12 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 52 15:33:12 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 193.000000 53 15:33:12 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 54 15:33:12 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 55 15:33:12 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 56 15:33:12 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 57 15:33:12 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 58 15:33:12 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 33302162 59 15:33:12 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 60 15:33:12 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2786116.000000 61 15:33:12 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 62 15:33:12 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 63 15:33:12 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 193.000000 64 15:33:12 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 65 15:33:12 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 15:33:12 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 67 15:33:12 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 68 15:33:12 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 69 15:33:12 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 34179420 70 15:33:12 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 71 15:33:12 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2786116.000000 72 15:33:12 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 73 15:33:12 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 74 15:33:12 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 193.000000 75 15:33:12 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 76 15:33:12 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 77 15:33:12 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 78 15:33:12 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 79 15:33:12 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 80 15:33:12 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 81 15:33:12 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2786116.000000 82 15:33:12 SQL Data In: ORACLE - Param = 3, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20050401 83 15:33:12 SQL Data In: ORACLE - Param = 4, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210203 84 15:33:12 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227769100484745 85 15:33:12 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 86 15:33:12 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 87 15:33:12 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 谢淑雯 88 15:33:12 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 89 15:33:12 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 90 15:33:12 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 91 15:33:12 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 92 15:33:12 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 93 15:33:12 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 94 15:33:12 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 95 15:33:12 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 96 15:33:12 SQL Data In: ORACLE - Param = 17, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 97 15:33:12 SQL Data In: ORACLE - Param = 18, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 98 15:33:12 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 99 15:33:12 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 100 15:33:12 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25测试库 101 15:33:12 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 193.000000 102 15:33:12 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 103 15:33:12 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11062 104 15:33:12 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 15:33:12 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 106 15:33:12 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 107 15:33:12 SQL Data In: ORACLE - Param = 28, Name = AS_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 108 15:33:12 SQL Data In: ORACLE - Param = 29, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 15:33:12 SQL Data In: ORACLE - Param = 30, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 15:33:12 SQL Data In: ORACLE - Param = 31, Name = as_SFSCJS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 111 15:33:12 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AS_SFDYFP => :AS_SFDYFP,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_SFSCJS => :as_SFSCJS); END; 112 15:33:12 SQL Execute: ORACLE - commit 113 15:33:12 SQL Data In: ORACLE - Rows affected = 0 114 15:33:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 115 15:33:12 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 116 15:33:14 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 117 15:33:14 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 118 15:33:14 SQL Execute: ORACLE - select * from vw_sf_brjflb 119 15:33:14 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 AND ZFFSBH <> 18 AND MZZYBZ in ('0','1') 120 15:33:14 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' 121 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 122 15:33:14 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' and MC0000 =? 123 15:33:14 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' 124 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 125 15:33:14 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' and MC0000 =? 126 15:33:14 SQL Execute: ORACLE - select * from BM_YHKDM0 where SFYX00='1' order by XSXH00 127 15:33:14 SQL Execute: ORACLE - select SF_SF_GETYJJPJXH('1',857,193) as PJXH00 from dual 128 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 129 15:33:14 SQL Execute: ORACLE - select A.*,B.FBMC00,substr(SF_XT_CSRQTONL_EX(a.BRCSRQ,a.BRCSSJ),1,10) as BRNL00 from BM_BRXXB0 A, BM_BRFBB0 B where A.fbbh00 = B.fbbh00 and A.BRID00 =? 130 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 131 15:33:14 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 132 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 133 15:33:14 SQL Execute: ORACLE - select a.*,a.XJYE00-greatest(0,a.TYJE00) as XJTYJE from SF_BRZHXX a where JFLBID = 1 and BRID00 = ? 134 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 135 15:33:14 SQL Execute: ORACLE - select tyje01,YBSBK0,ICKH00 from VW_SF_BRZHXX where brid00= ? 136 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 137 15:33:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 138 15:33:14 SQL Execute: ORACLE - select SUM(B.ZFJE00) JE0000,SUM(B.HJJE00) HJJE00 from VW_SF_YFMZCF A,YF_MZCFMX B where A.CFLSH0=B.CFLSH0 AND (A.BCCFH0 is null) and A.CFZT00 in ('0','a') and A.BRID00 = ? and ghid00 in(select ghid00 from sf_brxxb0 where GHRQ00>=to_char(sysdate-GHYXTS,'YYYYMMDD') and brid00= ?) 139 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 140 15:33:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 141 15:33:14 SQL Execute: ORACLE - select SUM(B.ZFJE00) JE0000,SUM(B.GFJE00+B.JZJE00+B.ZFJE00) HJJE00 from VW_SF_YJYW00 A,YJ_YWJJ00 B where A.YJDJH0=B.YJDJH0 AND (CXDJH0 is null) and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00= ? and ghid00 in(select ghid00 from sf_brxxb0 where GHRQ00>=to_char(sysdate-GHYXTS,'YYYYMMDD') and brid00= ?) 142 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 143 15:33:14 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 144 15:33:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 145 15:33:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 146 15:33:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 147 15:33:14 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual 148 15:33:18 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' 149 15:33:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 150 15:33:18 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='门诊医院结算银行可填支付方式' and YXBZ00='1' and MC0000 =? 151 15:33:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 152 15:33:18 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 153 15:33:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 154 15:33:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 155 15:33:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 156 15:33:18 SQL Execute: ORACLE - select SF_SF_PAY_KTKJE0(?,?,?) as FHXX00 from dual 157 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 158 15:33:23 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=? 159 15:33:23 SQL Execute: ORACLE - select * from BM_BRZFFS where ZFFSBH in (2,18) 160 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 161 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 162 15:33:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 163 15:33:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 164 15:33:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 165 15:33:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 166 15:33:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 167 15:33:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 168 15:33:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 169 15:33:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 170 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 171 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 172 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 173 15:33:23 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 174 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 175 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 176 15:33:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 177 15:33:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 178 15:33:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 179 15:33:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 180 15:33:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 181 15:33:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 182 15:33:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 183 15:33:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 184 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 185 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 186 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 187 15:33:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 188 15:33:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 189 15:33:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 190 15:33:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 191 15:33:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 192 15:33:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 193 15:33:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 194 15:33:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 195 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 196 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 197 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 198 15:33:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 199 15:33:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 200 15:33:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 201 15:33:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 202 15:33:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 203 15:33:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 204 15:33:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 205 15:33:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 206 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 207 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 208 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退预交金 209 15:33:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 210 15:33:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 211 15:33:23 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 28 212 15:33:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 213 15:33:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 214 15:33:23 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 215 15:33:23 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 216 15:33:23 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 217 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 218 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 219 15:33:23 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 220 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 221 15:33:23 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 222 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 223 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 224 15:33:23 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0 from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 225 15:33:23 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 226 15:33:23 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 139317.000000 227 15:33:23 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 228 15:33:23 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 229 15:33:23 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000 230 15:33:23 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 25测试库 231 15:33:23 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 232 15:33:23 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 233 15:33:23 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 234 15:33:23 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 235 15:33:23 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 236 15:33:23 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 平台支付 237 15:33:23 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000 238 15:33:23 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 239 15:33:23 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 240 15:33:23 SQL Data In: ORACLE - Param = 16, Name = PINCS00, Type = fldZSTRING, Precision = 67, Scale = 0, Data = 09330038||||139317|退预交金|平台支付|-0.01|0|N||20210203153323||193 241 15:33:23 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 242 15:33:23 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 243 15:33:23 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 244 15:33:23 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 245 15:33:23 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_ZFRZ00" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PZYHGHH => :PZYHGHH,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PJFBZ00 => :PJFBZ00,PJZDH00 => :PJZDH00,PYJDH00 => :PYJDH00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PJFJE00 => :PJFJE00,PFKTM00 => :PFKTM00,PTKDDH0 => :PTKDDH0,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END; 246 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 247 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 248 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 249 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 250 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 251 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 252 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 253 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 254 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 255 15:33:23 SQL Execute: ORACLE - COMMIT 256 15:33:23 SQL Data In: ORACLE - Rows affected = 0 257 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 258 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 259 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 260 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 261 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 262 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 263 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031533220349 264 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param 265 15:33:23 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 266 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031533220349 267 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra 268 15:33:23 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00 269 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 270 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 271 15:33:23 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 272 15:33:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = {"transType":"hop.trade.setinfo","param":{"serveraddr":"http://192.168.1.174:8060/onepay-web/oneweb/oneapi","appid":"1ESC4PDP9009AE01A8C000002A7ADB55","appsecret":"1ESC4PDOC00FAE01A8C000005EF91C22"},"notes":"缴费退款|0|09330038||||139317|退预交金|平台支付 273 15:33:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031533220349 274 15:33:23 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=? 275 15:33:23 SQL Data In: ORACLE - Rows affected = 1 276 15:33:23 SQL Execute: ORACLE - COMMIT 277 15:33:23 SQL Data In: ORACLE - Rows affected = 0 278 15:33:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 85, Scale = 0, Data = {"encryptType":"PLAIN","param":null,"respCode":"030002","respMsg":"原订单流水不存在"} 279 15:33:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030002 280 15:33:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 原订单流水不存在 281 15:33:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ202102031533220349 282 15:33:24 SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=? 283 15:33:24 SQL Data In: ORACLE - Rows affected = 1 284 15:33:24 SQL Execute: ORACLE - COMMIT 285 15:33:24 SQL Data In: ORACLE - Rows affected = 0 286 15:33:24 SQL Execute: ORACLE - Rollback 287 15:33:24 SQL Data In: ORACLE - Rows affected = 0