1 11:51:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 2 11:51:11 SQL Execute: ORACLE - select SF_ZY_SFQYDBZJK(?)SFQYBZ FROM dual 3 11:51:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 4 11:51:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = BZFZ00160 5 11:51:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6 11:51:11 SQL Execute: ORACLE - select SF_ZY_DBZJE00(?,?,?) DBZJE0 FROM dual 7 11:51:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 8 11:51:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 9 11:51:11 SQL Execute: ORACLE - select SF_ZY_FSDYLX(?,?) FHLX00 from dual 10 11:51:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 11 11:51:11 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 3 and PJSYR0 = ? and SYBZ00 = 'Y' 12 11:51:11 SQL Execute: ORACLE - select SF_ZY_SFXYYBSP(1619823) from dual 13 11:51:11 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 14 11:51:12 SQL Execute: ORACLE - select (select VALUE0 from XT_XTCS00 where NAME00='ZY_DBZJKQYSQM') VALUE0,SF_BM_SQXQTSXX('ZY_DBZJKQYSQM','0',1143,'326849430') TSXX00 from dual 15 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 16 11:51:12 SQL Execute: ORACLE - select count(*) NUM from zy_brxxb0 where ZYID00=? and BRZT00 = '3' 17 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 18 11:51:12 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where BCCFH0 is null and ZYID00=? and CFZT00 = '0' 19 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 20 11:51:12 SQL Execute: ORACLE - select count(*) NUM from yf_zycf00 where ZYID00=? and CFZT00='1' and SFKSLY='N' 21 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 22 11:51:12 SQL Execute: ORACLE - select count(*) NUM from VW_ZY_YJYW00 where cxdjh0 is null and ZYID00=? and ZJE000<>0 23 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 24 11:51:12 SQL Execute: ORACLE - select count(*) NUM from YF_YZYPSQ where ZYID00 =? and QLZT00='0' and CXBZ00 = 'Z' 25 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 26 11:51:12 SQL Execute: ORACLE - select sum(hjje00) NUM from zy_brfy00 where ZYID00=? 27 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 28 11:51:12 SQL Execute: ORACLE - select count(*) NUM from ZY_BRZHXX where BRID00 =? and SFDJ00 <> '2' and JFLBID <> 0 29 11:51:12 SQL Execute: ORACLE - select SF_ZY_BRRYLBXX('2','1619823') RYLB00 from dual 30 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 中途结算 31 11:51:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 32 11:51:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 33 11:51:12 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 34 11:51:12 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200515 35 11:51:12 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 11:51:12 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 37 11:51:12 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0320测试之女 38 11:51:12 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = BZFZ00160 39 11:51:12 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 11:51:12 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 41 11:51:12 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3800.000000 42 11:51:12 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 385.000000 43 11:51:12 SQL Execute: ORACLE - select SF_ZY_CHECK_CYJSDATA(?,?,?,?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 44 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 45 11:51:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 46 11:51:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 47 11:51:12 SQL Execute: ORACLE - select SF_ZY_ZRZYFY(?,?,?)FHXX00 from dual 48 11:51:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 49 11:51:12 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 50 11:51:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 51 11:51:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200515 52 11:51:13 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 40595501 53 11:51:13 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 54 11:51:13 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 55 11:51:13 SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0)HJJE00, nvl(sum(NVL(ZFJE00,0)),0)ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0)GFJE00,min(djh000) qsdjh0,max(djh000) zzdjh0 from zy_brfy00 where JZDH00+0 = 0 and JFLBID = ? and CZRQ00 <= ? and zyh000= ? and ZYID00 = ? and BRID00 = ? and yexm00 ='0320测试之女' 56 11:51:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 57 11:51:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 58 11:51:13 SQL Execute: ORACLE - select * from zy_brzhxx where 1 = 1 and JFLBID = ? and BRID00 = ? 59 11:51:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 60 11:51:13 SQL Execute: ORACLE - select * from ZY_BRJFB0 A where A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 61 11:51:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 62 11:51:13 SQL Execute: ORACLE - select A.*, B.PJXH00 from ZY_BRJFB0 A, ZY_PJSYQK B where A.PJH000 = B.PJH000 and B.PLBH00 in (4,8) and A.JZDH00+0 = 0 and JFLBID = 2 and A.BRID00 =? and A.JFBZ00 <> '2' 63 11:51:14 SQL Misc: ORACLE - Set stored procedure on or off 64 11:51:14 SQL Data In: ORACLE - Param = 1, Name = AS_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31276180.000000 65 11:51:14 SQL Data In: ORACLE - Param = 2, Name = AS_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31276180.000000 66 11:51:14 SQL Data In: ORACLE - Param = 3, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 11:51:14 SQL Data In: ORACLE - Param = 4, Name = AS_ZYH000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 40595501 68 11:51:14 SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1619823.000000 69 11:51:14 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4872546.000000 70 11:51:14 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 71 11:51:14 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 0320测试 72 11:51:14 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 73 11:51:14 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 74 11:51:14 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 385.000000 75 11:51:14 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 76 11:51:14 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 77 11:51:14 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 385.000000 78 11:51:14 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 79 11:51:14 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 80 11:51:14 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 81 11:51:14 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 82 11:51:14 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 385.000000 83 11:51:14 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 84 11:51:14 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 陈强 85 11:51:14 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 43.000000 86 11:51:14 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 87 11:51:14 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 88 11:51:14 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 89 11:51:14 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 90 11:51:14 SQL Data In: ORACLE - Param = 27, Name = AS_JFDJHS, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0,31276171,0 91 11:51:14 SQL Data In: ORACLE - Param = 28, Name = AS_JSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200515 92 11:51:14 SQL Data In: ORACLE - Param = 29, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 93 11:51:14 SQL Data In: ORACLE - Param = 30, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 11:51:14 SQL Data In: ORACLE - Param = 31, Name = AD_GZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 95 11:51:14 SQL Data In: ORACLE - Param = 32, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 11:51:14 SQL Data In: ORACLE - Param = 33, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 97 11:51:14 SQL Data In: ORACLE - Param = 34, Name = AD_XJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 98 11:51:14 SQL Data In: ORACLE - Param = 35, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 11:51:14 SQL Data In: ORACLE - Param = 36, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 100 11:51:14 SQL Data In: ORACLE - Param = 37, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 101 11:51:14 SQL Data In: ORACLE - Param = 38, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 102 11:51:14 SQL Data In: ORACLE - Param = 39, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 103 11:51:14 SQL Data In: ORACLE - Param = 40, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 104 11:51:14 SQL Data In: ORACLE - Param = 41, Name = AD_SBDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 105 11:51:14 SQL Data In: ORACLE - Param = 42, Name = AD_BJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 106 11:51:14 SQL Data In: ORACLE - Param = 43, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 107 11:51:14 SQL Data In: ORACLE - Param = 44, Name = ad_YYZFDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 108 11:51:14 SQL Data In: ORACLE - Param = 45, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 11:51:14 SQL Data In: ORACLE - Param = 46, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 11:51:14 SQL Data In: ORACLE - Param = 47, Name = ad_YEXM00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 0320测试之女 111 11:51:14 SQL Data In: ORACLE - Param = 48, Name = ad_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 112 11:51:14 SQL Data In: ORACLE - Param = 49, Name = ad_XFBXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 113 11:51:14 SQL Data In: ORACLE - Param = 50, Name = ad_XFBXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 114 11:51:14 SQL Data In: ORACLE - Param = 51, Name = ad_YBJKLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 115 11:51:14 SQL Data In: ORACLE - Param = 52, Name = ad_DDLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 116 11:51:14 SQL Execute: ORACLE - BEGIN "SP_ZY_BRFY00_JS0000" (AS_QSDJH0 => :AS_QSDJH0,AS_ZZDJH0 => :AS_ZZDJH0,AS_YBDJH0 => :AS_YBDJH0,AS_ZYH000 => :AS_ZYH000,AD_ZYID00 => :AD_ZYID00,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,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,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_JFDJHS => :AS_JFDJHS,AS_JSZZRQ => :AS_JSZZRQ,AS_TSBZBH => :AS_TSBZBH,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_XJDJH0 => :AD_XJDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_SBDJH0 => :AD_SBDJH0,AD_BJDJH0 => :AD_BJDJH0,AD_GWYDJH => :AD_GWYDJH,ad_YYZFDH => :ad_YYZFDH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_YEXM00 => :ad_YEXM00,ad_DBZBM0 => :ad_DBZBM0,ad_XFBXJE => :ad_XFBXJE,ad_XFBXID => :ad_XFBXID,ad_YBJKLX => :ad_YBJKLX,ad_DDLSH0 => :ad_DDLSH0); END;