1 21:36:24 SQL Execute: ORACLE - Select SYSDATE from Dual 2 21:36:24 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 3 21:36:24 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 4 21:36:24 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 5 21:36:25 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='PTYBPT30100661505' and ICKNBH ='PTYBPT30100661505' 6 21:36:25 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =669701 7 21:36:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 8 21:36:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YJ_XMYXTS' 9 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 10 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 11 21:36:25 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 12 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 13 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 14 21:36:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 15 21:36:25 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 16 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 17 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 18 21:36:25 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 19 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 20 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 21 21:36:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 22 21:36:25 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 23 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 24 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 25 21:36:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 26 21:36:25 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 27 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 28 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 29 21:36:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 30 21:36:25 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 31 21:36:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 32 21:36:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 33 21:36:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 34 21:36:25 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 35 21:36:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='YF_MZCFBLTS' 36 21:36:25 SQL Execute: ORACLE - select sum(B.HJJE00) NUM from sf_fymx00 b,SF_BRFY00 a where a.djh000=b.djh000 and b.xmbh00+0<>8000000001 and a.JFLBID=1 and a.JZDH00+0=0 and a.BRID00=669701 37 21:36:25 SQL Execute: ORACLE - select * from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 and D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in ( select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000 = B.DJH000 and B.JZDH00+0 = 0 and b.brid00=669701 ) 38 21:36:25 SQL Execute: ORACLE - select d.*,G.zlxmjc zlxmjc_1,F.GHRQ00 from VW_SF_YJYW00 D,YJ_YW0000 C,BM_ZLZD00 G,BM_ZLZD00 H,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 and d.brid00=669701 and D.SFDJH0+0 = 0 and D.YJDJH0=C.YJDJH0 AND C.ZLXMID=H.ZLXMID and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and a.brid00=669701) 39 21:36:25 SQL Execute: ORACLE - select * from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d where 1 = 1 and B.BRID00=669701 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000 = C.DJH000 and B.JZDH00+0 <> 0 and A.YPDLBH=D.LBBH00 40 21:36:25 SQL Execute: ORACLE - select A.*,B.JZDH00,g.zlxmjc zlxmjc_1 from VW_SF_YJYW00 A,YJ_YW0000 C,SF_BRFY00 B,SF_JZB000 D,SF_PJSYQK E,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 AND B.JZDH00=D.JZDH00 AND D.PJH000=E.PJH000 and A.CXDJH0 = C.YJDJH0 AND (E.PLBH00 = 1 or B.YBDJH0 <> 0) and C.SFDJH0 = B.DJH000 and B.JZDH00+0 <> 0 and A.SFDJH0+0 = 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and c.zlxmid=h.zlxmid and B.BRID00=669701 41 21:36:26 SQL Execute: ORACLE - select count(1) ss,C.LBMC00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 in( '0','5') and b.brid00=669701 and B.YPDLBH=C.LBBH00 group by C.LBMC00 42 21:36:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 43 21:36:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 44 21:36:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 45 21:36:26 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 46 21:36:26 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,XT_KSZXXM f,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.yjksbh=F.zxksbh and D.XMZT00 in( '1','2') and D.brid00=669701 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and f.ZXKSBH=e.bmbh00 and d.zlxmid=f.ZLXMID group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 47 21:36:26 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.XMZT00 in( '1','2') and D.brid00=669701 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 48 21:36:26 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 49 21:36:26 SQL Data In: ORACLE - Param = 2, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 21:36:26 SQL Data In: ORACLE - Param = 3, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 清账退卡 51 21:36:26 SQL Data In: ORACLE - Param = 4, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 52 21:36:26 SQL Data In: ORACLE - Param = 5, Name = PJYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 53 21:36:26 SQL Data In: ORACLE - Param = 6, Name = PQTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 54 21:36:26 SQL Data In: ORACLE - Param = 7, Name = PCXLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 55 21:36:26 SQL Data In: ORACLE - Param = 8, Name = PTKJLS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 21:36:26 SQL Data In: ORACLE - Param = 9, Name = PTKJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 57 21:36:26 SQL Data In: ORACLE - Param = 10, Name = PERRSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 21:36:26 SQL Data In: ORACLE - Param = 11, Name = PXTCS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 59 21:36:26 SQL Execute: ORACLE - BEGIN "SP_SF_PAY_TKDATA" (PBRID00 => :PBRID00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PMZZYBZ => :PMZZYBZ,PJYJE00 => :PJYJE00,PQTCS00 => :PQTCS00,PCXLSH0 => :PCXLSH0,PTKJLS0 => :PTKJLS0,PTKJE00 => :PTKJE00,PERRSTR => :PERRSTR,PXTCS00 => :PXTCS00); END; 60 21:36:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20190708212845 61 21:36:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 62 21:36:26 SQL Execute: ORACLE - select ZFFS00,ZFFSMC,sum(TKJE00)TKJE00 from PAY_YJJ_MXCX where CXLSH0=? and BRID00=? group by ZFFS00,ZFFSMC order by ZFFS00 desc 63 21:36:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20190708212845 64 21:36:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 65 21:36:27 SQL Execute: ORACLE - select * from PAY_YJJ_MXCX where CXLSH0=? and BRID00=? order by ZFFS00 desc,DJH000 desc 66 21:36:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 67 21:36:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊清账退卡 68 21:36:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 69 21:36:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 70 21:36:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24 71 21:36:27 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付 72 21:36:27 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 73 21:36:27 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 74 21:36:27 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 75 21:36:27 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 76 21:36:27 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 77 21:36:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 78 21:36:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊清账退卡 79 21:36:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 80 21:36:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 81 21:36:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24 82 21:36:27 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付 83 21:36:27 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 84 21:36:27 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 85 21:36:27 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 86 21:36:27 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 87 21:36:27 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 88 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 89 21:36:29 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 90 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 91 21:36:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 21:36:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 93 21:36:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 94 21:36:29 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24 95 21:36:29 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付 96 21:36:29 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 97 21:36:29 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 98 21:36:29 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 99 21:36:29 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 100 21:36:29 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 101 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 102 21:36:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 103 21:36:29 SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual 104 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = E 105 21:36:29 SQL Execute: ORACLE - Select count(1) as Num from BM_ZFFSMX A where A.ZFMXBH=? 106 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 107 21:36:29 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 108 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 109 21:36:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 110 21:36:29 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=? 111 21:36:29 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 112 21:36:29 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 113 21:36:29 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 114 21:36:29 SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 115 21:36:29 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 116 21:36:29 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 管理员csCS 117 21:36:29 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 118 21:36:29 SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 119 21:36:29 SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 120 21:36:29 SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 121 21:36:29 SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 122 21:36:29 SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付 123 21:36:29 SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000 124 21:36:29 SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 125 21:36:29 SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128110641 126 21:36:29 SQL Data In: ORACLE - Param = 16, Name = PPJXH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 127 21:36:29 SQL Data In: ORACLE - Param = 17, Name = PZDBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 128 21:36:29 SQL Data In: ORACLE - Param = 18, Name = PZFQDBM, Type = fldZSTRING, Precision = 5, Scale = 0, Data = RBPAY 129 21:36:29 SQL Data In: ORACLE - Param = 19, Name = PZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 21:36:29 SQL Data In: ORACLE - Param = 20, Name = PZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 21:36:29 SQL Data In: ORACLE - Param = 21, Name = PZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 132 21:36:29 SQL Data In: ORACLE - Param = 22, Name = PINCS00, Type = fldZSTRING, Precision = 153, Scale = 0, Data = 13|0|18896145|MZ201907082128110641|EHTS1907080000028438|20190708t10121340100000000814899|669701|门诊清账退卡|PTYBPT30100661505|-0.01|0|N|20190708212846|E 133 21:36:29 SQL Data In: ORACLE - Param = 23, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 134 21:36:29 SQL Data In: ORACLE - Param = 24, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 135 21:36:29 SQL Data In: ORACLE - Param = 25, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 136 21:36:29 SQL Data In: ORACLE - Param = 26, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 137 21:36:29 SQL Execute: ORACLE - BEGIN "SP_SF_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); END; 138 21:36:29 SQL Execute: ORACLE - COMMIT 139 21:36:29 SQL Data In: ORACLE - Rows affected = 0 140 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 141 21:36:29 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and VALUE0 is not null and FSLX00 in ('0','2') order by ZDBM00 142 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 32, Scale = 0, Data = AC7503DE03EE93D5826829DF148DAE19 143 21:36:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 45, Scale = 0, Data = AC7503DE03EE93D5826829DF148DAE19 144 21:36:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 145 21:36:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = sign 146 21:36:29 SQL Execute: ORACLE - update BM_ZFRZMX set VALUE0=?, XML000=? where DDLSH0=? and ZDBM00=? 147 21:36:29 SQL Data In: ORACLE - Rows affected = 1 148 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 149 21:36:29 SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and FSLX00 in ('0','2') order by MXID00 150 21:36:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 151 21:36:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = E 152 21:36:29 SQL Execute: ORACLE - Select * from BM_ZFFSMX where ZFFSBH=? and ZFMXBH=? 153 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SUCCESS 154 21:36:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 155 21:36:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 156 21:36:31 SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=?,OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=? 157 21:36:31 SQL Data In: ORACLE - Rows affected = 1 158 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 159 21:36:31 SQL Execute: ORACLE - select * from BM_ZFRZMX where DDLSH0=? and FSLX00 in ('1','2') 160 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 32, Scale = 0, Data = DBEB9BFC53DCAFAE3A67BBC95FAC0110 161 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 162 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = sign 163 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 164 21:36:31 SQL Data In: ORACLE - Rows affected = 1 165 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SUCCESS 166 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 167 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = result 168 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 169 21:36:31 SQL Data In: ORACLE - Rows affected = 1 170 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SUCCESS 171 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 172 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = code 173 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 174 21:36:31 SQL Data In: ORACLE - Rows affected = 1 175 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 成功 176 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 177 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = code_message 178 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 179 21:36:31 SQL Data In: ORACLE - Rows affected = 1 180 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20190708213440 181 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 182 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = refund_success_time 183 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 184 21:36:31 SQL Data In: ORACLE - Rows affected = 1 185 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = EHTS1907080000028438 186 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 187 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = trade_no 188 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 189 21:36:31 SQL Data In: ORACLE - Rows affected = 2 190 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 32, Scale = 0, Data = c32494d71a964d398c0452c66418fc85 191 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 192 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = refund_no 193 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 194 21:36:31 SQL Data In: ORACLE - Rows affected = 1 195 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 32, Scale = 0, Data = 20190708t20000000000000000008997 196 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 197 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = wt_refund_no 198 21:36:31 SQL Execute: ORACLE - update BM_ZFRZMX set JKFHZ0=? where DDLSH0=? and ZDBM00=? 199 21:36:31 SQL Data In: ORACLE - Rows affected = 1 200 21:36:31 SQL Execute: ORACLE - COMMIT 201 21:36:31 SQL Data In: ORACLE - Rows affected = 0 202 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = RBPAY 203 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SUCCESS 204 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 205 21:36:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 206 21:36:31 SQL Execute: ORACLE - Select SF_SF_PAYZT0(?,?,?,?)FHXX00 from dual 207 21:36:31 SQL Data In: ORACLE - Param = 1, Name = PDDLSH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 208 21:36:31 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 209 21:36:31 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 210 21:36:31 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 211 21:36:31 SQL Data In: ORACLE - Param = 5, Name = PZYHGHH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 212 21:36:31 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 213 21:36:31 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 管理员csCS 214 21:36:31 SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 215 21:36:31 SQL Data In: ORACLE - Param = 9, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 216 21:36:31 SQL Data In: ORACLE - Param = 10, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 217 21:36:31 SQL Data In: ORACLE - Param = 11, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付 218 21:36:31 SQL Data In: ORACLE - Param = 12, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -0.010000 219 21:36:31 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 220 21:36:31 SQL Data In: ORACLE - Param = 14, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 221 21:36:31 SQL Data In: ORACLE - Param = 15, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 222 21:36:31 SQL Execute: ORACLE - BEGIN "SP_SF_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; 223 21:36:31 SQL Execute: ORACLE - COMMIT 224 21:36:31 SQL Data In: ORACLE - Rows affected = 0 225 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 669701.000000 226 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = MZ201907082128480642 227 21:36:31 SQL Execute: ORACLE - select * from BM_ZFRZ00 where BRID00=? and DDLSH0=? 228 21:36:31 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 =1 and SYBZ00 = 'Y' 229 21:36:31 SQL Execute: ORACLE - select BRZJBH,brid00 from BM_BRXXB0 where BRBLH0='*689604' and BRZJLX='身份证' 230 21:36:31 SQL Execute: ORACLE - SELECT a.*,decode('N','Y','补打','N',' ') SFBD00 FROM VW_SF_BRJFXX a where a.DJH000=0 231 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 232 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 233 21:36:31 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 234 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 235 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 236 21:36:31 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 237 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 238 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 239 21:36:31 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 240 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 241 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 242 21:36:31 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 243 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 244 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 245 21:36:31 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 246 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 247 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 248 21:36:31 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 249 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 250 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 251 21:36:31 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 252 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 253 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 254 21:36:31 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 255 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 256 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 257 21:36:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 258 21:36:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 259 21:36:31 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 260 21:36:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 261 21:36:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 262 21:36:31 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence