1 11:12:39 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',18,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1142,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1142 AND b.JSKSBH = '18') AND (INSTR (',' || a.jsksbh || ',',',18,') > 0 or a.jsksbh is null) 2 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480408.000000 3 11:12:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 4 11:12:39 SQL Execute: ORACLE - select sum(HJJE00)HJJE00 from ZY_BRFY00 where BRID00=? and ZYID00=? and JZDH00=0 5 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 6 11:12:39 SQL Execute: ORACLE - select count(1) as num from yf_zycf00 where CFZT00='1' and ZYID00=? 7 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 8 11:12:39 SQL Execute: ORACLE - select count(*) NUM from YF_YZYPSQ where ZYID00 =? and QLZT00 in ('0','5') and CXBZ00 <> 'Z' 9 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 10 11:12:39 SQL Execute: ORACLE - select count(*) NUM from YF_ZYCF00 A where A.ZYID00 = ? and A.CFZT00 in ('0','5') and A.BCCFH0 in (select CFLSH0 from yf_zycf00 E,zy_brfy00 F where E.DJH000 = F.DJH000 and F.JZDH00 = 0 and F.ZYID00 = A.ZYID00 ) 11 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 12 11:12:39 SQL Execute: ORACLE - select count(*) NUM from VW_ZY_YJYW00 A where A.ZYID00 = ? and A.CXDJH0 in ( select YJDJH0 from YJ_YW0000 where ZYGHID = A.ZYID00 and SFDJH0 in ( select DJH000 from ZY_BRFY00 where JZDH00 = 0 and ZYID00=A.ZYID00)) and A.SFDJH0+0 = 0 13 11:12:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 14 11:12:39 SQL Execute: ORACLE - select count(*) NUM from bq_yjyz00 A where A.ZYID00 = ? and A.ZLXMID = 0 and A.ZLXMJC like '%垫付%' 15 11:12:40 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 16 11:12:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数 17 11:12:40 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 18 11:12:40 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 19 11:12:40 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='多点结算接口参数' and BH0000='DDJSJK_SQM') VALUE0,SF_BM_SQXQTSXX('DDJSJK_SQM','多点结算接口参数',1142,'84566171') TSXX00 from dual 20 11:12:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 21 11:12:40 SQL Execute: ORACLE - select b.ZYH000,b.BRID00,b.ZYID00,b.FBBH00,b.YBZYH0,b.RYRQ00,b.RYSJ00,b.RYLB00, b.RYBQ00,b.DQBQ00,b.RYCWH0,b.CYRQ00,b.CYSJ00,b.DBZBM0,b.YBLB00,b.YBBRLB, a.BRBLH0,a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRCSRQ,a.BRZJLX,a.BRZJBH, a.BRDH00,a.BRLXXM,a.BRLXDZ,a.BRLXDH from bm_brxxb0 a,zy_brxxb0 b where a.brid00=b.brid00 and b.zyid00=? 22 11:12:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1142.000000 23 11:12:40 SQL Execute: ORACLE - Select a.*,b.bmmc00 from bm_ygbm00 a,bm_bmbm00 b where a.bmbh00=b.bmbh00 and a.YGBH00=? 24 11:12:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 25 11:12:40 SQL Execute: ORACLE - Select b.* from bm_bmbm00 b where b.bmbh00=? 26 11:12:40 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 27 11:12:40 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('20025DD870784','多点结算HIS请求参数','2002501DDD多点结算11142林苗苗18480408779622405222202106130131720582Y1142林苗苗') 28 11:12:40 SQL Data In: ORACLE - Rows affected = 1 29 11:12:40 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20025.000000 30 11:12:40 SQL Data In: ORACLE - Param = 2, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD 31 11:12:40 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480408.000000 32 11:12:40 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 779622.000000 33 11:12:40 SQL Data In: ORACLE - Param = 5, Name = PCARDNO, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 405222 34 11:12:40 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 11:12:40 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1142.000000 36 11:12:40 SQL Data In: ORACLE - Param = 8, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林苗苗 37 11:12:40 SQL Data In: ORACLE - Param = 9, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 38 11:12:40 SQL Data In: ORACLE - Param = 10, Name = PKSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210613 39 11:12:40 SQL Data In: ORACLE - Param = 11, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 11:12:40 SQL Data In: ORACLE - Param = 12, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 41 11:12:40 SQL Data In: ORACLE - Param = 13, Name = PYBGHH0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 131720582 42 11:12:40 SQL Data In: ORACLE - Param = 14, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 11:12:40 SQL Data In: ORACLE - Param = 15, Name = PCSNBID, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 20025DD870784 44 11:12:40 SQL Data In: ORACLE - Param = 16, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 45 11:12:40 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 46 11:12:40 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 11:12:40 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 48 11:12:40 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 49 11:12:40 SQL Execute: ORACLE - BEGIN "SP_ZY_DDJSJKRZ" (PJKLXBH => :PJKLXBH,PJKLX00 => :PJKLX00,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PCARDNO => :PCARDNO,PMZZYBZ => :PMZZYBZ,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PJZDH00 => :PJZDH00,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PCSNBID => :PCSNBID,PBYRC00 => :PBYRC00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END; 50 11:12:40 SQL Execute: ORACLE - COMMIT 51 11:12:40 SQL Data In: ORACLE - Rows affected = 0 52 11:12:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202106171113410120 53 11:12:41 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and JDBM00 in ('Readcard_Info') and FSLX00 in ('2','3') order by MXID00 54 11:12:41 SQL Execute: ORACLE - COMMIT 55 11:12:41 SQL Data In: ORACLE - Rows affected = 0 56 11:12:41 SQL Execute: ORACLE - rollback 57 11:12:41 SQL Data In: ORACLE - Rows affected = 0