1 16:22:44 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 2 16:22:44 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 3 16:22:44 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4521992 4 16:22:44 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857258.000000 5 16:22:44 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 16:22:44 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 7 16:22:44 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 8 16:22:44 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 9 16:22:44 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 10 16:22:44 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 11 16:22:44 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4521992 12 16:22:44 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857258.000000 13 16:22:44 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 16:22:44 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 16:22:44 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 16:22:44 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 17 16:22:44 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 18 16:22:44 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 16:22:44 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4521992 20 16:22:44 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福州市医保中心 21 16:22:44 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857258.000000 22 16:22:44 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 23 16:22:44 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 24 16:22:44 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 16:22:44 SQL Data In: ORACLE - Param = 9, Name = as_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 16:22:44 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_TSBZBH => :as_TSBZBH); END; 27 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4521992 28 16:22:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 29 16:22:44 SQL Execute: ORACLE - select max(A.GHRQ00) GHRQ00,to_char(sysdate,'YYYYMMDD') DTDATE from SF_BRXXB0 A,SF_BRFY00 b,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.BRID00 = B.BRID00 and A.LBBH00 = B.JFLBID and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and TRIM(A.YBGHH0)<>'0' and a.ghh000=? and A.BRID00 = ? 30 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 31 16:22:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4521992 32 16:22:44 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where brid00= ? and ghh000= ? order by ghid00 desc 33 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 34 16:22:44 SQL Execute: ORACLE - select SFXNH0 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 35 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 36 16:22:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 37 16:22:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 38 16:22:44 SQL Execute: ORACLE - select SF_SF_YBBZBM(?,?,?) FSLX00 from dual 39 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1891086.000000 40 16:22:44 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT,max(YSXM00) YSXM00 from BM_SFCFMX_TEMP00 where ID0000 = ? 41 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4521992 42 16:22:44 SQL Execute: ORACLE - Select * from VW_SF_BRMZZZ where GHH000=? and rownum<=10 43 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 44 16:22:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20191216 45 16:22:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20191216 46 16:22:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857258.000000 47 16:22:44 SQL Execute: ORACLE - select count(*) ZJL,nvl(sum(decode(sign(HJJE00),-1,1,0)),0) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 =? and jzrq00>=? and jzrq00<=? and mzid00 in (select mzid00 from sf_jzb000 where jzdh00=? ) 48 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1891086.000000 49 16:22:44 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'Y' 50 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1891086.000000 51 16:22:44 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = ? and BZ0000 = 'N' 52 16:22:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1891086.000000 53 16:22:44 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = ? 54 16:22:44 SQL Execute: ORACLE - Select * from SF_XMFSDY where SYBFS0=1 order by PXXH00 55 16:22:44 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 56 16:22:57 SQL Execute: ORACLE - rollback 57 16:22:57 SQL Data In: ORACLE - Rows affected = 0 58 16:22:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 59 16:22:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4521992 60 16:22:57 SQL Execute: ORACLE - select bxlb00 from sf_brxxb0 where brid00= ? and ghh000= ? order by ghid00 desc 61 16:22:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 62 16:22:57 SQL Execute: ORACLE - select SFXNH0 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 63 16:22:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 64 16:22:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1641862.000000 65 16:22:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 16:22:57 SQL Execute: ORACLE - select SF_SF_YBBZBM(?,?,?) FSLX00 from dual 67 16:22:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1891086.000000 68 16:22:57 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT,max(YSXM00) YSXM00 from BM_SFCFMX_TEMP00 where ID0000 = ? 69 16:22:58 SQL Execute: ORACLE - RollBack 70 16:22:58 SQL Data In: ORACLE - Rows affected = 0 71 16:22:58 SQL Execute: ORACLE - rollback 72 16:22:58 SQL Data In: ORACLE - Rows affected = 0