1 15:41:41 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')
2 15:41:41 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1
3 15:41:41 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1
4 15:41:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
5 15:41:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
6 15:41:41 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual
7 15:41:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000
8 15:41:41 SQL Execute: ORACLE - select * from vw_zy_brjflb where JFLBID <> 0
9 15:41:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
10 15:41:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
11 15:41:41 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual
12 15:41:41 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1
and ZFFSBH not in (18,20,26)
order by nvl(XSXH00,0),ZFFSBH
13 15:41:41 SQL Execute: ORACLE - select * from bm_bmbm00 where BMXZ00 = '9' and flag00='1'
14 15:41:41 SQL Execute: ORACLE - select * from BM_YHKDM0
15 15:41:41 SQL Execute: ORACLE - Select SF_SF_GETPJH('8','189') from dual
16 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0262984
17 15:41:45 SQL Execute: ORACLE - select a.* ,(select bmmc00 from bm_bmbm00 b where b.bmbh00=a.DQBQ00 and rownum=1)DQBQMC from ZY_BRXXB0 a where 1=1
and ZYH000 = ?
and CYRQ00 is NULL
18 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
19 15:41:45 SQL Execute: ORACLE - select A.*,B.FBMC00,C.YBMC00 from BM_BRXXB0 A, BM_BRFBB0 B,IC_YBBRLB C where A.fbbh00 = B.fbbh00 and A.FBBH00 = C.FBBH00 and A.YBLB00 = C.YBLB00
and BRID00 in ( select BRID00 from ZY_BRXXB0
where brid00= ?
and CYRQ00 is NULL and substr(brzt00,1,1) in ('1','2','3','8'))
20 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
21 15:41:45 SQL Execute: ORACLE - select * from IC_YHXX00 where BRID00 = ? and ZT0000='1'
22 15:41:45 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_ZY'
23 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
24 15:41:45 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
25 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
26 15:41:45 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
27 15:41:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
28 15:41:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
29 15:41:45 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=?
30 15:41:46 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000
31 15:41:46 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
32 15:41:46 SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0262984
33 15:41:46 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
34 15:41:46 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 谢萍
35 15:41:46 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
36 15:41:46 SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 预交金充值余额下载
37 15:41:46 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
38 15:41:46 SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
39 15:41:46 SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
40 15:41:46 SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
41 15:41:46 SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
42 15:41:46 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;
43 15:41:46 SQL Execute: ORACLE - Rollback
44 15:41:46 SQL Data In: ORACLE - Rows affected = 0
45 15:41:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
46 15:41:46 SQL Execute: ORACLE - select SFDJ00,XJYE00,ZZYE00,BJJE00,TYJE00,YXQFJE,SP_SF_KYJE00(0,BRID00) KYJE00,SF_BQ_KYJE00(0,BRID00) BQKYJE,YBYJS0,YBYZF0,SF_ZY_BRDBJE(0,brid00) BRDBJE from ZY_BRZHXX where JFLBID = 2 and BRID00 = ?
47 15:41:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
48 15:41:46 SQL Execute: ORACLE - select * from ZY_BRXXB0 where BRID00=? and ((FBBH00='3' and instr(','||'N'||',',','||YBZXLB||',')>0 ) or 'N'='N' )
49 15:41:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
50 15:41:46 SQL Execute: ORACLE - select Sum(JFJE00)JFJE00 from ZY_BRJFB0 where 1 = 1 and ZFFS00 in (1,2,8,24,25)
and BRID00 = ?
51 15:41:46 SQL Execute: ORACLE - select a.DQBQ00,a.rycwh0,a.zyh000,a.xm0000 from ZY_BRXXB0 a,BM_BMBM00 b where a.ZYID00=426595 and a.dqks00=b.bmbh00 and rownum=1
52 15:41:46 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
53 15:41:46 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
54 15:41:46 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.000000
55 15:41:46 SQL Data In: ORACLE - Param = 4, Name = PTQRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 11/24/2020 0:0:0:0
56 15:41:46 SQL Data In: ORACLE - Param = 5, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
57 15:41:46 SQL Data In: ORACLE - Param = 6, Name = PCFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
58 15:41:46 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZTQ_DBRYTQ" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PTQRQ00 => :PTQRQ00,PBCTQID => :PBCTQID,PCFJE00 => :PCFJE00); END;
59 15:41:46 SQL Execute: ORACLE - select nvl(sum(CFZJE0),0) from yf_zycf00 where zyid00=426595 and bccfh0 is null and cfzt00='0'
60 15:41:46 SQL Execute: ORACLE - select nvl(sum(b.LSDJ00*b.YPZSL0),0) as YPJE00 from YF_YZYPSQ b where b.ZYID00=426595 and b.CXBZ00 in ('Z','+') and b.FYBZ00='0' and b.QLZT00 in ('0')
61 15:41:46 SQL Execute: ORACLE - select nvl(sum(b.LSDJ00*b.YPZSL0),0) as YPJE00 from BQ_YZYPSQ b where b.ID0000=6229180 and b.ZYID00=426595
62 15:41:46 SQL Execute: ORACLE - select nvl(sum(a.SFJE00*a.CS0000),0) as JE0000 from VW_BQ_YXFJXM a where a.zyid00=426595 and exists (select 1 from BQ_ZBTQYZ c where c.id0000=6229180 and c.sjbz00='1' and c.YZID00=a.YZID00)
63 15:41:46 SQL Execute: ORACLE - select nvl(sum(a.SFJE00*a.CS0000),0) as JE0000 from VW_BQ_YXFJXM a,VW_BQ_YZZXJL_WZX c where c.zyid00=426595 and c.yzid00=a.yzid00
64 15:41:46 SQL Execute: ORACLE - SELECT nvl(sum(CS0000*SFJE00),0) as JE0000 from VW_BQ_BRJZXM where zyid00=426595 and Tzrq00 is null and XMLB00='0' AND TRUNC(sysdate)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(sysdate)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0
65 15:41:46 SQL Execute: ORACLE - select nvl(sum(decode(CLBZ00,'0',a.MCSL00*(select b.sfje00 from VW_ZS_ZLXMSF b where b.zlxmid=a.zlxmid and rownum=1)*(to_date(to_char(sysdate,'YYYYMMDD'),'YYYYMMDD')-to_date(QYRQ00,'YYYYMMDD')), a.MCSL00*(select b.sfje00 from VW_ZS_ZLXMSF b where b.zlxmid=a.zlxmid and rownum=1) )),0) as JE0000 from BQ_YJYZ00 a where a.zyid00=426595 and a.yzzt00='1' and a.TQRQ00 is null and exists (select 1 from VW_ZS_ZLXMSF where ZLXMID=a.ZLXMID)
union
select nvl(sum(a.zje000),0) JE0000 from VW_ZY_YJYW00 a where CXDJH0 is null and SFDJH0 = 0 and ZYID00 =426595
66 15:41:46 SQL Execute: ORACLE - delete BQ_ZBTQYZ where ID0000=6229180
67 15:41:46 SQL Data In: ORACLE - Rows affected = 0
68 15:41:46 SQL Execute: ORACLE - delete BQ_YZYPSQ where ID0000=6229180
69 15:41:46 SQL Data In: ORACLE - Rows affected = 0
70 15:41:46 SQL Execute: ORACLE - Commit
71 15:41:46 SQL Data In: ORACLE - Rows affected = 0
72 15:41:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350124197311221707
73 15:41:46 SQL Execute: ORACLE - select count(1) num from BM_MZJZBR where BRSFZH = ?
and not exists(select 1 from XT_XTCS00 where NAME00='ZY_MZJZBRYH' and VALUE0 = 'Y')
74 15:41:46 SQL Execute: ORACLE - select a.DQBQ00,a.rycwh0,a.zyh000,a.xm0000 from ZY_BRXXB0 a,BM_BMBM00 b where a.ZYID00=426595 and a.dqks00=b.bmbh00 and rownum=1
75 15:41:46 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
76 15:41:46 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
77 15:41:46 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.000000
78 15:41:46 SQL Data In: ORACLE - Param = 4, Name = PTQRQ00, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 11/24/2020 0:0:0:0
79 15:41:46 SQL Data In: ORACLE - Param = 5, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
80 15:41:46 SQL Data In: ORACLE - Param = 6, Name = PCFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
81 15:41:46 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZTQ_DBRYTQ" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PTQRQ00 => :PTQRQ00,PBCTQID => :PBCTQID,PCFJE00 => :PCFJE00); END;
82 15:41:46 SQL Execute: ORACLE - select nvl(sum(CFZJE0),0) from yf_zycf00 where zyid00=426595 and bccfh0 is null and cfzt00='0'
83 15:41:46 SQL Execute: ORACLE - select nvl(sum(b.LSDJ00*b.YPZSL0),0) as YPJE00 from YF_YZYPSQ b where b.ZYID00=426595 and b.CXBZ00 in ('Z','+') and b.FYBZ00='0' and b.QLZT00 in ('0')
84 15:41:46 SQL Execute: ORACLE - select nvl(sum(b.LSDJ00*b.YPZSL0),0) as YPJE00 from BQ_YZYPSQ b where b.ID0000=6229181 and b.ZYID00=426595
85 15:41:46 SQL Execute: ORACLE - select nvl(sum(a.SFJE00*a.CS0000),0) as JE0000 from VW_BQ_YXFJXM a where a.zyid00=426595 and exists (select 1 from BQ_ZBTQYZ c where c.id0000=6229181 and c.sjbz00='1' and c.YZID00=a.YZID00)
86 15:41:46 SQL Execute: ORACLE - select nvl(sum(a.SFJE00*a.CS0000),0) as JE0000 from VW_BQ_YXFJXM a,VW_BQ_YZZXJL_WZX c where c.zyid00=426595 and c.yzid00=a.yzid00
87 15:41:46 SQL Execute: ORACLE - SELECT nvl(sum(CS0000*SFJE00),0) as JE0000 from VW_BQ_BRJZXM where zyid00=426595 and Tzrq00 is null and XMLB00='0' AND TRUNC(sysdate)-TO_DATE(QSRQ00,'YYYYMMDD')>=0 AND TRUNC(sysdate)-DECODE(SF_BQ_COMPARE(TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD'),TO_DATE(QSRQ00,'YYYYMMDD')), -1,TO_DATE('20000101','YYYYMMDD')-1,TO_DATE(NVL(GZRQ00,'20000101'),'YYYYMMDD') )>0
88 15:41:46 SQL Execute: ORACLE - select nvl(sum(decode(CLBZ00,'0',a.MCSL00*(select b.sfje00 from VW_ZS_ZLXMSF b where b.zlxmid=a.zlxmid and rownum=1)*(to_date(to_char(sysdate,'YYYYMMDD'),'YYYYMMDD')-to_date(QYRQ00,'YYYYMMDD')), a.MCSL00*(select b.sfje00 from VW_ZS_ZLXMSF b where b.zlxmid=a.zlxmid and rownum=1) )),0) as JE0000 from BQ_YJYZ00 a where a.zyid00=426595 and a.yzzt00='1' and a.TQRQ00 is null and exists (select 1 from VW_ZS_ZLXMSF where ZLXMID=a.ZLXMID)
union
select nvl(sum(a.zje000),0) JE0000 from VW_ZY_YJYW00 a where CXDJH0 is null and SFDJH0 = 0 and ZYID00 =426595
89 15:41:46 SQL Execute: ORACLE - delete BQ_ZBTQYZ where ID0000=6229181
90 15:41:46 SQL Data In: ORACLE - Rows affected = 0
91 15:41:46 SQL Execute: ORACLE - delete BQ_YZYPSQ where ID0000=6229181
92 15:41:46 SQL Data In: ORACLE - Rows affected = 0
93 15:41:46 SQL Execute: ORACLE - Commit
94 15:41:46 SQL Data In: ORACLE - Rows affected = 0
95 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
96 15:42:00 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 = ?
and SYBZ00 = 'Y'
97 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
98 15:42:00 SQL Execute: ORACLE - select * from zy_brxxb0 where BRID00 =? and cyrq00 is null
99 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
100 15:42:00 SQL Execute: ORACLE - SELECT * FROM VW_ZY_BRZFFS WHERE ZFFSBH = ?
101 15:42:00 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
102 15:42:00 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='支付统一平台参数' and BH0000='JKQYSQM') VALUE0,SF_BM_SQXQTSXX('JKQYSQM','支付统一平台参数',189,'137506634') TSXX00 from dual
103 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
104 15:42:00 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC=?
105 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
106 15:42:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
107 15:42:00 SQL Execute: ORACLE - SELECT a.* FROM BM_ZFFSMX a
where ZFFSBH=? and YXBZ00=?
order by a.XSXH00
108 15:42:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
109 15:42:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = E
110 15:42:00 SQL Execute: ORACLE - SELECT a.* FROM BM_ZFFSMX a
where ZFFSBH=? and ZFMXBH=?
111 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
112 15:42:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
113 15:42:13 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual
114 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
115 15:42:13 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
116 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
117 15:42:13 SQL Execute: ORACLE - SELECT * FROM VW_SF_BRZFFS WHERE ZFFSBH = ?
118 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
119 15:42:13 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
120 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
121 15:42:13 SQL Execute: ORACLE - select a.*,b.* from bm_brxxb0 a,zy_brxxb0 b where a.brid00=b.brid00 and b.zyid00=?
122 15:42:13 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
123 15:42:13 SQL Execute: ORACLE - insert into BM_ZFPTCS(NBID00,JKQQCS)values ('29705','1J22收预交金024微信支付0.01YJPAYEY127403942659502629840000||||426595|收预交金|微信支付|0.01|0|N|E|20201124154159134893430668209589020201124154212000N00')
124 15:42:13 SQL Data In: ORACLE - Rows affected = 1
125 15:42:13 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
126 15:42:13 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
127 15:42:13 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
128 15:42:13 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0262984
129 15:42:13 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
130 15:42:13 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 谢萍
131 15:42:13 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
132 15:42:13 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
133 15:42:13 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
134 15:42:13 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
135 15:42:13 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
136 15:42:13 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
137 15:42:13 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.010000
138 15:42:13 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 134893430668209589
139 15:42:13 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
140 15:42:13 SQL Data In: ORACLE - Param = 16, Name = PPJXH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
141 15:42:13 SQL Data In: ORACLE - Param = 17, Name = PZDBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
142 15:42:13 SQL Data In: ORACLE - Param = 18, Name = PZFQDBM, Type = fldZSTRING, Precision = 5, Scale = 0, Data = YJPAY
143 15:42:13 SQL Data In: ORACLE - Param = 19, Name = PZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
144 15:42:13 SQL Data In: ORACLE - Param = 20, Name = PZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
145 15:42:13 SQL Data In: ORACLE - Param = 21, Name = PZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
146 15:42:13 SQL Data In: ORACLE - Param = 22, Name = PINCS00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 22|0|0||||426595|收预交金|微信支付|0.01|0|N|E|20201124154159
147 15:42:13 SQL Data In: ORACLE - Param = 23, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
148 15:42:13 SQL Data In: ORACLE - Param = 24, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
149 15:42:13 SQL Data In: ORACLE - Param = 25, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
150 15:42:13 SQL Data In: ORACLE - Param = 26, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
151 15:42:13 SQL Data In: ORACLE - Param = 27, Name = PJKQQCS, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 29705
152 15:42:13 SQL Data In: ORACLE - Param = 28, Name = PZFMXBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = E
153 15:42:13 SQL Data In: ORACLE - Param = 29, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 47.000000
154 15:42:13 SQL Execute: ORACLE - BEGIN "SP_ZY_PAY_YNZFRZ" (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,PPJXH00 => :PPJXH00,PZDBH00 => :PZDBH00,PZFQDBM => :PZFQDBM,PZPKHYH => :PZPKHYH,PZPDWMC => :PZPDWMC,PZPH000 => :PZPH000,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG,PJKQQCS => :PJKQQCS,PZFMXBH => :PZFMXBH,PCZYKS0 => :PCZYKS0); END;
155 15:42:13 SQL Execute: ORACLE - COMMIT
156 15:42:13 SQL Data In: ORACLE - Rows affected = 0
157 15:42:13 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from dual
158 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
159 15:42:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra
160 15:42:13 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00
161 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
162 15:42:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param
163 15:42:13 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00
164 15:42:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
165 15:42:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
166 15:42:13 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00
167 15:42:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
168 15:42:13 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=?
169 15:42:13 SQL Data In: ORACLE - Rows affected = 1
170 15:42:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
171 15:42:15 SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=? where DDLSH0=?
172 15:42:15 SQL Data In: ORACLE - Rows affected = 1
173 15:42:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
174 15:42:15 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=?
and FSLX00 in ('1','2')
order by MXID00
175 15:42:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2004271546355050000
176 15:42:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
177 15:42:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = mchId
178 15:42:15 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
179 15:42:15 SQL Data In: ORACLE - Rows affected = 1
180 15:42:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2004271547064600001
181 15:42:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
182 15:42:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = appId
183 15:42:15 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
184 15:42:15 SQL Data In: ORACLE - Rows affected = 1
185 15:42:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2008131743442960426
186 15:42:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
187 15:42:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = businessType
188 15:42:15 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
189 15:42:15 SQL Data In: ORACLE - Rows affected = 1
190 15:42:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
191 15:42:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
192 15:42:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = mchOrderNo
193 15:42:15 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
194 15:42:16 SQL Data In: ORACLE - Rows affected = 1
195 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1274039
196 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
197 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = mchOrderId
198 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
199 15:42:16 SQL Data In: ORACLE - Rows affected = 1
200 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 1606203733000
201 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
202 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = mchOrderTime
203 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
204 15:42:16 SQL Data In: ORACLE - Rows affected = 1
205 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
206 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
207 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = amount
208 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
209 15:42:16 SQL Data In: ORACLE - Rows affected = 1
210 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cny
211 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
212 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = currency
213 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
214 15:42:16 SQL Data In: ORACLE - Rows affected = 1
215 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = P002011241545312558732
216 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
217 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = payOrderId
218 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
219 15:42:16 SQL Data In: ORACLE - Rows affected = 1
220 15:42:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
221 15:42:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
222 15:42:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = status
223 15:42:16 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
224 15:42:16 SQL Data In: ORACLE - Rows affected = 1
225 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
226 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param
227 15:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? and ZDBM00 in('mchId','appId','mchOrderNo','timeStamp') order by MXID00
228 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
229 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
230 15:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? and ZDBM00 in ('reqKey','resKey') order by MXID00
231 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
232 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param
233 15:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? and ZDBM00 in('mchId','appId','mchOrderNo','timeStamp') order by MXID00
234 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
235 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
236 15:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? and ZDBM00 in ('reqKey','resKey') order by MXID00
237 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
238 15:42:19 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=?
and FSLX00 in ('1','2')
order by MXID00
239 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2004271546355050000
240 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
241 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = mchId
242 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
243 15:42:19 SQL Data In: ORACLE - Rows affected = 1
244 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2004271547064600001
245 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
246 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = appId
247 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
248 15:42:19 SQL Data In: ORACLE - Rows affected = 1
249 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2008131743442960426
250 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
251 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = businessType
252 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
253 15:42:19 SQL Data In: ORACLE - Rows affected = 1
254 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
255 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
256 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = mchOrderNo
257 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
258 15:42:19 SQL Data In: ORACLE - Rows affected = 1
259 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1274039
260 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
261 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = mchOrderId
262 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
263 15:42:19 SQL Data In: ORACLE - Rows affected = 1
264 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 1606203733000
265 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
266 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = mchOrderTime
267 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
268 15:42:19 SQL Data In: ORACLE - Rows affected = 1
269 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
270 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
271 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = amount
272 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
273 15:42:19 SQL Data In: ORACLE - Rows affected = 1
274 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = cny
275 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
276 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = currency
277 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
278 15:42:19 SQL Data In: ORACLE - Rows affected = 1
279 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = P002011241545312558732
280 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
281 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = payOrderId
282 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
283 15:42:19 SQL Data In: ORACLE - Rows affected = 1
284 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
285 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
286 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = status
287 15:42:19 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=?
288 15:42:19 SQL Data In: ORACLE - Rows affected = 1
289 15:42:19 SQL Execute: ORACLE - insert into BM_YJZFLS (SHLSH0,YWBH00,SHDDH0,PTLSH0,LSLX00,JE0000,LSRQSJ,ZT0000) values ('ZY202011241542120193','2008131743442960426','1274039','P002011241545312558732','1',1,'1606203733000','2')
290 15:42:19 SQL Data In: ORACLE - Rows affected = 1
291 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
292 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 交款成功
293 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = ->接口交互:2
294 15:42:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
295 15:42:19 SQL Execute: ORACLE - update BM_ZFRZ00 set JKXYBM=?,JKXYXX=?,BZ0000=? where DDLSH0=?
296 15:42:19 SQL Data In: ORACLE - Rows affected = 1
297 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = YJPAY
298 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
299 15:42:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
300 15:42:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
301 15:42:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
302 15:42:19 SQL Execute: ORACLE - Select SF_ZY_PAYZT0(?,?,?,?,?)FHXX00 from dual
303 15:42:19 SQL Execute: ORACLE - COMMIT
304 15:42:19 SQL Data In: ORACLE - Rows affected = 0
305 15:42:19 SQL Data In: ORACLE - Param = 1, Name = PDDLSH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
306 15:42:19 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
307 15:42:19 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
308 15:42:19 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
309 15:42:19 SQL Data In: ORACLE - Param = 5, Name = PZYHGHH, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0262984
310 15:42:19 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 189.000000
311 15:42:19 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 谢萍
312 15:42:19 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
313 15:42:19 SQL Data In: ORACLE - Param = 9, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
314 15:42:19 SQL Data In: ORACLE - Param = 10, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
315 15:42:19 SQL Data In: ORACLE - Param = 11, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
316 15:42:19 SQL Data In: ORACLE - Param = 12, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.010000
317 15:42:19 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
318 15:42:19 SQL Data In: ORACLE - Param = 14, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
319 15:42:19 SQL Data In: ORACLE - Param = 15, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
320 15:42:19 SQL Execute: ORACLE - BEGIN "SP_ZY_PAY_YNZFQR" (PDDLSH0 => :PDDLSH0,PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PZYHGHH => :PZYHGHH,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PJFBZ00 => :PJFBZ00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PJFJE00 => :PJFJE00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
321 15:42:19 SQL Execute: ORACLE - COMMIT
322 15:42:19 SQL Data In: ORACLE - Rows affected = 0
323 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1274039.000000
324 15:42:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202011241542120193
325 15:42:19 SQL Execute: ORACLE - select * from BM_ZFRZ00 where BRID00=? and DDLSH0=?
326 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
327 15:42:19 SQL Execute: ORACLE - select * from ZY_BRJFB0 where DJH000=?
328 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
329 15:42:19 SQL Execute: ORACLE - select B.BMMC00,A.RYCWH0,A.BRID00 from zy_brxxb0 A,bm_bmbm00 B where A.DQBQ00 = B.BMBH00 and A.ZYID00=?
330 15:42:19 SQL Execute: ORACLE - select BRBLH0 from bm_brxxb0 where brid00='1274039'
331 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
332 15:42:19 SQL Execute: ORACLE - select COUNT(*) JKCS00 from zy_brxxb0 A,ZY_PJSYQK B,ZY_BRJFB0 C where B.PLBH00=8 AND A.ZYID00 = C.ZYID00 AND C.PJH000=B.PJH000 and A.ZYID00=?
333 15:42:19 SQL Execute: ORACLE - select A.ICKH00 from IC_YHXX00 A,BM_BRXXB0 B where A.BRID00 = B.BRID00 and B.MRN000 = '0262984'
334 15:42:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 426595.000000
335 15:42:19 SQL Execute: ORACLE - select * from ZY_BRXXB0 A where A.ZYID00=?
336 15:42:19 SQL Execute: ORACLE - SELECT A.*,A.DXJFJE||'(￥'||JFJE00||')' JFJE01,'(￥'||A.BRYE00||')' BRYE01,to_char(sysdate,'yyyy-mm-dd') JFRQ01,'谢萍' ||'/' || 'S207' SFY001,' ' SFBD00 FROM VW_ZY_BRJFPJ A where A.DJH000=0
337 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
338 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
339 15:42:20 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=?
340 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
341 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
342 15:42:20 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence
343 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
344 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
345 15:42:20 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence
346 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
347 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
348 15:42:20 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence
349 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
350 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
351 15:42:20 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence
352 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
353 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
354 15:42:20 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence
355 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
356 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
357 15:42:20 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence
358 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
359 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
360 15:42:20 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence
361 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
362 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
363 15:42:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
364 15:42:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
365 15:42:20 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID
366 15:42:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
367 15:42:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
368 15:42:20 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence