1 11:10:56 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '多点结算接口参数' and BH0000 = 'Open_MZ' 2 11:10:56 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '多点结算接口参数' and BH0000 = 'MZSFQYZJJS' 3 11:10:56 SQL Execute: ORACLE - select SF_YJ_ZJJSXZ('7','0',1111,16,5990841,501) MSG from dual 4 11:10:56 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '多点结算接口参数' and BH0000 = 'MZZJCZ_CZY' 5 11:10:56 SQL Execute: ORACLE - select BMBH00 from BM_YGBM00 where YGBH00=1134 6 11:10:56 SQL Execute: ORACLE - select SF_SF_DDJS_REQUEST_HISXML('20014DD0113410615015990841') as preply from dual 7 11:10:56 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 8 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数 9 11:10:56 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 10 11:10:56 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 11 11:10:56 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='多点结算接口参数' and BH0000='DDJSJK_SQM') VALUE0,SF_BM_SQXQTSXX('DDJSJK_SQM','多点结算接口参数',1134,'83510422') TSXX00 from dual 12 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 501.000000 13 11:10:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 14 11:10:56 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,C.XJYE00,C.ZZYE00,C.ZYE000 from bm_brxxb0 a,IC_YHXX00 B,SF_BRZHXX C where A.BRID00=B.BRID00 and A.BRID00=C.BRID00 AND a.brid00=? and B.ZT0000=? 15 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1134.000000 16 11:10:56 SQL Execute: ORACLE - Select a.*,b.bmmc00 from bm_ygbm00 a,bm_bmbm00 b where a.bmbh00=b.bmbh00 and a.YGBH00=? 17 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1061.000000 18 11:10:56 SQL Execute: ORACLE - Select b.* from bm_bmbm00 b where b.bmbh00=? 19 11:10:56 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 20 11:10:56 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('20014DD922388','多点结算HIS请求参数','20014DD01134多点结算10615015990841NPYBH540571293Y1') 21 11:10:56 SQL Data In: ORACLE - Rows affected = 1 22 11:10:56 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20014.000000 23 11:10:56 SQL Data In: ORACLE - Param = 2, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD 24 11:10:56 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 501.000000 25 11:10:56 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5990841.000000 26 11:10:56 SQL Data In: ORACLE - Param = 5, Name = PCARDNO, Type = fldZSTRING, Precision = 13, Scale = 0, Data = NPYBH54057129 27 11:10:56 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 11:10:56 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1134.000000 29 11:10:56 SQL Data In: ORACLE - Param = 8, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 多点结算 30 11:10:56 SQL Data In: ORACLE - Param = 9, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1061.000000 31 11:10:56 SQL Data In: ORACLE - Param = 10, Name = PKSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 32 11:10:56 SQL Data In: ORACLE - Param = 11, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 11:10:56 SQL Data In: ORACLE - Param = 12, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 34 11:10:56 SQL Data In: ORACLE - Param = 13, Name = PYBGHH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 35 11:10:56 SQL Data In: ORACLE - Param = 14, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 36 11:10:56 SQL Data In: ORACLE - Param = 15, Name = PCSNBID, Type = fldZSTRING, Precision = 13, Scale = 0, Data = 20014DD922388 37 11:10:56 SQL Data In: ORACLE - Param = 16, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 11:10:56 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 39 11:10:56 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 11:10:56 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 11:10:56 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 11:10:56 SQL Execute: ORACLE - BEGIN "SP_SF_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; 43 11:10:56 SQL Execute: ORACLE - COMMIT 44 11:10:56 SQL Data In: ORACLE - Rows affected = 0 45 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 46 11:10:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = Header 47 11:10:56 SQL Execute: ORACLE - Select * from SF_YBFSZX where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00 48 11:10:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 49 11:10:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Body 50 11:10:56 SQL Execute: ORACLE - Select * from SF_YBFSZX where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00 51 11:11:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 178, Scale = 0, Data =
YLMPS.01.01.0100000000000000000结算成功
 52 11:11:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 53 11:11:12 SQL Execute: ORACLE - update SF_YBJK00 set JKFHCS=? where DDLSH0=? 54 11:11:12 SQL Data In: ORACLE - Rows affected = 1 55 11:11:12 SQL Execute: ORACLE - COMMIT 56 11:11:12 SQL Data In: ORACLE - Rows affected = 0 57 11:11:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 58 11:11:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 结算成功 59 11:11:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 60 11:11:12 SQL Execute: ORACLE - update SF_YBJK00 set JKFHBM=?,JKFHXX=? where DDLSH0=? 61 11:11:12 SQL Data In: ORACLE - Rows affected = 1 62 11:11:12 SQL Execute: ORACLE - COMMIT 63 11:11:12 SQL Data In: ORACLE - Rows affected = 0 64 11:11:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 65 11:11:12 SQL Execute: ORACLE - Select * from SF_YBFSZX where DDLSH0=? and FSLX00 in ('2','3') order by MXID00 66 11:11:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 11:11:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 68 11:11:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = result 69 11:11:12 SQL Execute: ORACLE - update SF_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=? 70 11:11:12 SQL Data In: ORACLE - Rows affected = 1 71 11:11:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 结算成功 72 11:11:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202204211110564058 73 11:11:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = msg 74 11:11:12 SQL Execute: ORACLE - update SF_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=? 75 11:11:12 SQL Data In: ORACLE - Rows affected = 1 76 11:11:12 SQL Execute: ORACLE - COMMIT 77 11:11:12 SQL Data In: ORACLE - Rows affected = 0 78 11:11:12 SQL Execute: ORACLE - COMMIT 79 11:11:12 SQL Data In: ORACLE - Rows affected = 0