1 21:51:34 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 2 21:51:35 SQL Execute: ORACLE - select NULL ICKH00,NULL KLBMC0,A.* from BM_BRXXB0 A where not exists ( select * from ic_yhxx00 where brid00 = A.brid00 and ZT0000 in ('1','2')) 3 21:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 4 21:51:39 SQL Execute: ORACLE - select * from BM_BRXXB0 where brid00 =? 5 21:51:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 6 21:51:39 SQL Execute: ORACLE - select count(*) SFZF from ic_yhxx00 where brid00=? and zt0000='3' 7 21:51:39 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 8 21:51:39 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 9 21:51:39 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 10 21:51:40 SQL Execute: ORACLE - Select SYSDATE from Dual 11 21:51:40 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 12 21:51:40 SQL Execute: ORACLE - Select VALUE0 From XT_XTCS00 Where NAME00 = 'IC_YBYYJKLM' 13 21:51:40 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') 14 21:51:41 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0227494600010381' and ICKNBH = '0227494600010381' 15 21:51:41 SQL Execute: ORACLE - select count(*) NUM,NVL(max(ICKJE0),0) ICKJE0 from IC_YHXX00 where ICKH00 = '0227494600010381' and ZT0000='0' 16 21:51:44 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 17 21:51:54 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 18 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 21:51:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 20 21:51:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 21 21:51:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 21:51:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 23 21:51:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 24 21:51:58 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual 25 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 26 21:51:58 SQL Execute: ORACLE - select NVL(ZYE000,0) YE0000 from SF_BRZHXX where brid00 =? and JFLBID = 1 27 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 28 21:51:58 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00=? 29 21:51:58 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 30 21:51:58 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 31 21:51:58 SQL Data In: ORACLE - Param = 3, Name = AS_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 32 21:51:58 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 33 21:51:58 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 34 21:51:58 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 35 21:51:58 SQL Data In: ORACLE - Param = 7, Name = AS_CARDBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 36 21:51:58 SQL Data In: ORACLE - Param = 8, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 37 21:51:58 SQL Data In: ORACLE - Param = 9, Name = AS_SFSQKF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 38 21:51:58 SQL Data In: ORACLE - Param = 10, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 39 21:51:58 SQL Data In: ORACLE - Param = 11, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 21:51:58 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 41 21:51:58 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 42 21:51:58 SQL Execute: ORACLE - BEGIN "SP_SF_ICK000_CHANGE" (AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AS_OLDKH0 => :AS_OLDKH0,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_CARDBZ => :AS_CARDBZ,AS_CZBZ00 => :AS_CZBZ00,AS_SFSQKF => :AS_SFSQKF,AS_YBZHYE => :AS_YBZHYE,AD_JZDH00 => :AD_JZDH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 43 21:51:58 SQL Execute: ORACLE - Commit 44 21:51:58 SQL Data In: ORACLE - Rows affected = 0 45 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 46 21:51:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 47 21:51:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 48 21:51:58 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 49 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 50 21:51:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 51 21:51:58 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 52 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 53 21:51:58 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 54 21:51:58 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 55 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 56 21:51:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 57 21:51:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 58 21:51:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 59 21:51:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 60 21:51:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 61 21:51:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 62 21:51:58 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 63 21:51:58 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 64 21:51:58 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 65 21:51:58 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 66 21:51:58 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 67 21:51:58 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 21:51:58 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 69 21:51:58 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 21:51:58 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 71 21:51:58 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 72 21:51:58 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 73 21:51:58 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 74 21:51:58 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 75 21:51:58 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 76 21:51:58 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 77 21:51:58 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 78 21:51:58 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 79 21:51:58 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 21:51:58 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 81 21:51:58 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 82 21:51:58 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 83 21:51:58 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 84 21:51:58 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 85 21:51:58 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 86 21:51:58 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 87 21:51:58 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 88 21:51:58 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 89 21:51:58 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 90 21:51:58 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 91 21:51:58 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 92 21:51:58 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 93 21:51:58 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 94 21:51:58 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 95 21:51:58 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 96 21:51:58 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 97 21:51:58 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 21:51:58 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 99 21:51:58 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 100 21:51:58 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 101 21:51:58 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 緍`d 102 21:51:58 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 晐( 103 21:51:58 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 21:51:58 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 105 21:51:58 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 106 21:51:58 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 107 21:51:58 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 108 21:51:58 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 21:51:58 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 110 21:51:58 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 111 21:51:58 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 112 21:51:58 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 113 21:51:58 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 114 21:51:58 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 115 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 116 21:51:58 SQL Execute: ORACLE - Select B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from IC_YHXX00 B where ICKH00=? 117 21:51:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 118 21:51:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 119 21:51:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 120 21:51:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 121 21:51:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 122 21:51:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 123 21:51:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 124 21:51:58 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 125 21:51:59 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 426|0|0 126 21:51:59 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 127 21:51:59 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 128 21:51:59 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 129 21:51:59 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 21:51:59 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 131 21:51:59 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 132 21:51:59 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 133 21:51:59 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 134 21:51:59 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 135 21:51:59 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 136 21:51:59 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 137 21:51:59 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 138 21:51:59 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 139 21:51:59 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 140 21:51:59 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 141 21:51:59 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 142 21:51:59 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 143 21:51:59 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 144 21:51:59 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 145 21:51:59 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 146 21:51:59 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 147 21:51:59 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 148 21:51:59 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 149 21:51:59 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 150 21:51:59 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 151 21:51:59 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 152 21:51:59 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 153 21:51:59 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 154 21:51:59 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 155 21:51:59 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 156 21:51:59 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 157 21:51:59 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 158 21:51:59 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 159 21:51:59 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 160 21:51:59 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 161 21:51:59 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 162 21:51:59 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 163 21:51:59 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 緍`d, 164 21:51:59 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 晐(, 165 21:51:59 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 166 21:51:59 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 卡记录不存在 167 21:51:59 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 168 21:51:59 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 169 21:51:59 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 170 21:51:59 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 171 21:51:59 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 172 21:51:59 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 173 21:51:59 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 174 21:51:59 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 175 21:51:59 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 176 21:51:59 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 177 21:52:04 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 178 21:52:14 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 179 21:52:19 SQL Execute: ORACLE - Rollback 180 21:52:19 SQL Data In: ORACLE - Rows affected = 0 181 21:52:24 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 182 21:52:25 SQL Execute: ORACLE - select * from BM_YHKDM0 183 21:52:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 184 21:52:25 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 = ? and SYBZ00 = 'Y' 185 21:52:26 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 186 21:52:26 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 187 21:52:26 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 188 21:52:26 SQL Execute: ORACLE - select * from vw_sf_brjflb 189 21:52:26 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 AND ZFFSBH <> 18 190 21:52:26 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 191 21:52:27 SQL Execute: ORACLE - Select SYSDATE from Dual 192 21:52:27 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 193 21:52:27 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') 194 21:52:27 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0227494600010381' and ICKNBH ='0227494600010381' 195 21:52:27 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =127405 196 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 197 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 198 21:52:27 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 199 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 200 21:52:27 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 201 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 202 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 203 21:52:27 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 204 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 205 21:52:27 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 206 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 207 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 208 21:52:27 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual 209 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 210 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1000 211 21:52:27 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual 212 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 213 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001 214 21:52:27 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual 215 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 216 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 217 21:52:27 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 218 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 219 21:52:27 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 220 21:52:27 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 221 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 222 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 223 21:52:27 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 224 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 225 21:52:27 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 226 21:52:27 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 227 21:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 228 21:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 229 21:52:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 230 21:52:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 231 21:52:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 232 21:52:27 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 233 21:52:27 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 234 21:52:27 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 235 21:52:27 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 236 21:52:27 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 237 21:52:27 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 238 21:52:27 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 239 21:52:27 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 240 21:52:27 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 241 21:52:27 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 242 21:52:27 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 243 21:52:27 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 244 21:52:27 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 245 21:52:27 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 246 21:52:27 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 247 21:52:27 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 248 21:52:27 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 249 21:52:27 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 250 21:52:27 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 251 21:52:27 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 252 21:52:27 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 253 21:52:27 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 254 21:52:27 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 255 21:52:27 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 256 21:52:27 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 257 21:52:27 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 258 21:52:27 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 259 21:52:27 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 260 21:52:27 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 261 21:52:27 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 262 21:52:27 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 263 21:52:27 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 264 21:52:27 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 265 21:52:27 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 266 21:52:27 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 267 21:52:27 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 268 21:52:27 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 269 21:52:27 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 270 21:52:27 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 271 21:52:27 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 272 21:52:27 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 273 21:52:27 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 12, Scale = 0, Data =  274 21:52:27 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 100, Scale = 0, Data = P坾 275 21:52:27 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 276 21:52:27 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 277 21:52:27 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 278 21:52:27 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 279 21:52:27 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 280 21:52:27 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 281 21:52:27 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 282 21:52:27 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 283 21:52:27 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 284 21:52:27 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 285 21:52:27 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 286 21:52:27 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 287 21:52:27 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 427|0|0 288 21:52:27 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 289 21:52:27 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 290 21:52:27 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 291 21:52:27 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 292 21:52:27 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 293 21:52:27 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 294 21:52:27 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 295 21:52:27 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 296 21:52:27 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 297 21:52:27 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 298 21:52:27 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 299 21:52:27 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 300 21:52:27 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 301 21:52:27 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 302 21:52:27 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 303 21:52:27 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 304 21:52:27 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 305 21:52:27 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 306 21:52:27 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 307 21:52:27 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 308 21:52:27 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 309 21:52:27 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 310 21:52:27 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 311 21:52:27 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 312 21:52:27 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 313 21:52:27 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 314 21:52:27 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 315 21:52:27 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 316 21:52:27 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 317 21:52:27 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 318 21:52:27 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 319 21:52:27 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 320 21:52:27 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 321 21:52:27 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 322 21:52:27 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 323 21:52:27 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 324 21:52:27 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 0|0.0|0.0 325 21:52:27 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 326 21:52:27 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 327 21:52:27 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 328 21:52:27 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 329 21:52:27 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 330 21:52:27 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 331 21:52:27 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 332 21:52:27 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 333 21:52:27 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 334 21:52:27 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 335 21:52:27 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 336 21:52:27 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 337 21:52:27 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 338 21:52:27 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 339 21:52:27 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 427|0|0 340 21:52:27 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 341 21:52:27 SQL Data In: ORACLE - Param = 3, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 342 21:52:27 SQL Data In: ORACLE - Param = 4, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 343 21:52:27 SQL Data In: ORACLE - Param = 5, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 344 21:52:27 SQL Data In: ORACLE - Param = 6, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 345 21:52:27 SQL Data In: ORACLE - Param = 7, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 346 21:52:27 SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 347 21:52:27 SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 348 21:52:27 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_KFB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_INJKCS => :P_INJKCS,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 349 21:52:34 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 350 21:52:34 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 351 21:52:34 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 352 21:52:34 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 353 21:52:34 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 354 21:52:34 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SGLRKH' and rownum=1 355 21:52:35 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 356 21:52:37 SQL Execute: ORACLE - Select SYSDATE from Dual 357 21:52:37 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 358 21:52:37 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') 359 21:52:37 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0227494600010381' and ICKNBH ='0227494600010381' 360 21:52:37 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =127405 361 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 362 21:52:37 SQL Execute: ORACLE - select BRID00 FROM ic_yhxx00 where ickh00=? and ZT0000='1' 363 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 364 21:52:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 365 21:52:37 SQL Execute: ORACLE - select a.brid00,a.brxm00,a.brxb00,a.brblh0,a.mrn000,b.fbmc00,c.zye000,c.yktye0,d.yyid00,d.icguid,d.ickh00,d.kmh000 from BM_BRXXB0 A, BM_BRFBB0 B, SF_BRZHXX C ,IC_YHXX00 D where 1=1 and A.FBBH00 = B.FBBH00 and A.BRID00 = C.BRID00 and C.JFLBID=1 and A.BRID00 = D.BRID00 AND D.ICKH00=? and ZT0000='1' and A.BRID00=? 366 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 367 21:52:37 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00=? 368 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 369 21:52:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 370 21:52:37 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 371 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 372 21:52:37 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 373 21:52:37 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 374 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 375 21:52:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 376 21:52:37 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 377 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 378 21:52:37 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 379 21:52:37 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 380 21:52:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 381 21:52:37 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 382 21:52:37 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 383 21:52:37 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 384 21:52:37 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 385 21:52:37 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 386 21:52:37 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 387 21:52:37 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 388 21:52:37 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 389 21:52:37 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 390 21:52:37 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 391 21:52:37 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 392 21:52:37 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 393 21:52:37 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 394 21:52:37 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 395 21:52:37 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 396 21:52:37 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 397 21:52:37 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 398 21:52:37 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 399 21:52:37 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 400 21:52:37 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 401 21:52:37 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 402 21:52:37 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 403 21:52:37 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 404 21:52:37 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 405 21:52:37 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 406 21:52:37 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 407 21:52:37 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 408 21:52:37 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 409 21:52:37 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 410 21:52:37 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 411 21:52:37 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 412 21:52:37 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 413 21:52:37 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 414 21:52:37 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 415 21:52:37 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 416 21:52:37 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 417 21:52:37 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 418 21:52:37 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 419 21:52:37 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 420 21:52:37 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 421 21:52:37 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 422 21:52:37 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 423 21:52:37 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 424 21:52:37 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 425 21:52:37 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 426 21:52:37 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 14, Scale = 0, Data =   427 21:52:37 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 17, Scale = 0, Data = `纄誻緮褀[!詗 V 428 21:52:37 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 429 21:52:37 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 430 21:52:37 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 431 21:52:37 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 432 21:52:37 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 433 21:52:37 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 434 21:52:37 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 435 21:52:37 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 436 21:52:37 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 437 21:52:37 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 438 21:52:37 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 439 21:52:37 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 440 21:52:37 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 428|0|0 441 21:52:37 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 442 21:52:37 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 443 21:52:37 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 444 21:52:37 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 445 21:52:37 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 446 21:52:37 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 447 21:52:37 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 448 21:52:37 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 449 21:52:37 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 450 21:52:37 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 451 21:52:37 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 452 21:52:37 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 453 21:52:37 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 454 21:52:37 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 455 21:52:37 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 456 21:52:37 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 457 21:52:37 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 458 21:52:37 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 459 21:52:37 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 460 21:52:37 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 461 21:52:37 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 462 21:52:37 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 463 21:52:37 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 464 21:52:37 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 465 21:52:37 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 466 21:52:37 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 467 21:52:37 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 468 21:52:37 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 469 21:52:37 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 470 21:52:37 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 471 21:52:37 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 472 21:52:37 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 473 21:52:37 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 474 21:52:37 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 475 21:52:37 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 476 21:52:37 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 477 21:52:37 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 0|0.0|0.0 478 21:52:37 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 479 21:52:37 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 480 21:52:37 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 481 21:52:37 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 该卡未在一卡通系统注册过！ 482 21:52:37 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 483 21:52:37 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 484 21:52:37 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 485 21:52:37 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 486 21:52:37 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 487 21:52:37 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 488 21:52:37 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 489 21:52:37 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 490 21:52:37 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 491 21:52:37 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 492 21:52:37 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 428|0|0 493 21:52:37 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 494 21:52:37 SQL Data In: ORACLE - Param = 3, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 495 21:52:37 SQL Data In: ORACLE - Param = 4, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 496 21:52:37 SQL Data In: ORACLE - Param = 5, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 497 21:52:37 SQL Data In: ORACLE - Param = 6, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 498 21:52:37 SQL Data In: ORACLE - Param = 7, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 499 21:52:37 SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 500 21:52:37 SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 501 21:52:37 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_KFB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_INJKCS => :P_INJKCS,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 502 21:52:44 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 503 21:52:54 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null) 504 21:52:54 SQL Execute: ORACLE - Select SYSDATE from Dual 505 21:52:54 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 506 21:52:54 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') 507 21:52:55 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0227494600010381' and ICKNBH ='0227494600010381' 508 21:52:55 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =127405 509 21:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 510 21:52:55 SQL Execute: ORACLE - select BRID00 FROM ic_yhxx00 where ickh00=? and ZT0000='1' 511 21:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 512 21:52:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 513 21:52:55 SQL Execute: ORACLE - select a.brid00,a.brxm00,a.brxb00,a.brblh0,a.mrn000,b.fbmc00,c.zye000,c.yktye0,d.yyid00,d.icguid,d.ickh00,d.kmh000 from BM_BRXXB0 A, BM_BRFBB0 B, SF_BRZHXX C ,IC_YHXX00 D where 1=1 and A.FBBH00 = B.FBBH00 and A.BRID00 = C.BRID00 and C.JFLBID=1 and A.BRID00 = D.BRID00 AND D.ICKH00=? and ZT0000='1' and A.BRID00=? 514 21:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 515 21:52:55 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00=? 516 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 517 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 518 21:52:56 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 519 21:52:56 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 520 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 521 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 522 21:52:56 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 523 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 524 21:52:56 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 525 21:52:56 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 526 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 527 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 528 21:52:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 529 21:52:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 530 21:52:56 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 531 21:52:56 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 532 21:52:56 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 533 21:52:56 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 534 21:52:56 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 535 21:52:56 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 536 21:52:56 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 537 21:52:56 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 538 21:52:56 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 539 21:52:56 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 540 21:52:56 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 541 21:52:56 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 542 21:52:56 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 543 21:52:56 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 544 21:52:56 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 545 21:52:56 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 546 21:52:56 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 547 21:52:56 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 548 21:52:56 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 549 21:52:56 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 550 21:52:56 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 551 21:52:56 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 552 21:52:56 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 553 21:52:56 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 554 21:52:56 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 555 21:52:56 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 556 21:52:56 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 557 21:52:56 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 558 21:52:56 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 559 21:52:56 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 560 21:52:56 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 561 21:52:56 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 562 21:52:56 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 563 21:52:56 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 564 21:52:56 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 565 21:52:56 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 566 21:52:56 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 567 21:52:56 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 568 21:52:56 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 569 21:52:56 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 570 21:52:56 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 571 21:52:56 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 572 21:52:56 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 573 21:52:56 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 100, Scale = 0, Data =  574 21:52:56 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 575 21:52:56 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 576 21:52:56 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 577 21:52:56 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 578 21:52:56 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 579 21:52:56 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 580 21:52:56 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 581 21:52:56 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 582 21:52:56 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 583 21:52:56 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 584 21:52:56 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 585 21:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 586 21:52:56 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 429|0| 587 21:52:56 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 588 21:52:56 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 589 21:52:56 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 590 21:52:56 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 591 21:52:56 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 592 21:52:56 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 593 21:52:56 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 594 21:52:56 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 595 21:52:56 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 596 21:52:56 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 597 21:52:56 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 598 21:52:56 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 599 21:52:56 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 600 21:52:56 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 601 21:52:56 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 602 21:52:56 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 603 21:52:56 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 604 21:52:56 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 605 21:52:56 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 606 21:52:56 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 607 21:52:56 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 608 21:52:56 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 609 21:52:56 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 610 21:52:56 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 611 21:52:56 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 612 21:52:56 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 613 21:52:56 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 614 21:52:56 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 615 21:52:56 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 616 21:52:56 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 617 21:52:56 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 618 21:52:56 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 619 21:52:56 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 620 21:52:56 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 621 21:52:56 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 622 21:52:56 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 623 21:52:56 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 1|0|0 624 21:52:56 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = , 625 21:52:56 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 3, Scale = 0, Data = , 626 21:52:56 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 627 21:52:56 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 628 21:52:56 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 629 21:52:56 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 630 21:52:56 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32150 631 21:52:56 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 632 21:52:56 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 633 21:52:56 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 634 21:52:56 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 635 21:52:56 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 636 21:52:56 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 637 21:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 638 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 639 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 640 21:52:56 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 641 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 642 21:52:56 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 643 21:52:56 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 644 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 645 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 646 21:52:56 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 647 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 648 21:52:56 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 649 21:52:56 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 650 21:52:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 651 21:52:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 652 21:52:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 653 21:52:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 654 21:52:56 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 655 21:52:56 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 656 21:52:56 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 657 21:52:56 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 658 21:52:56 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 659 21:52:56 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 660 21:52:56 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 661 21:52:56 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 662 21:52:56 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 663 21:52:56 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 664 21:52:56 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 665 21:52:56 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 666 21:52:56 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 667 21:52:56 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 668 21:52:56 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 669 21:52:56 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 670 21:52:56 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 671 21:52:56 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 672 21:52:56 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 673 21:52:56 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 674 21:52:56 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 675 21:52:56 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 676 21:52:56 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 677 21:52:56 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 678 21:52:56 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 679 21:52:56 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 680 21:52:56 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 681 21:52:56 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8 682 21:52:56 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 683 21:52:56 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 93.12 684 21:52:56 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 685 21:52:56 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 686 21:52:56 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 687 21:52:56 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 688 21:52:56 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 689 21:52:56 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 690 21:52:56 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 691 21:52:56 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 692 21:52:56 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 693 21:52:56 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 694 21:52:56 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 695 21:52:56 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 696 21:52:56 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0鈾| 697 21:52:56 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 31, Scale = 0, Data = 殀霄亅宾亅 698 21:52:56 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 699 21:52:56 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 700 21:52:56 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 701 21:52:56 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 702 21:52:56 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32150 703 21:52:56 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 704 21:52:56 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 705 21:52:56 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 706 21:52:56 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 707 21:52:56 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 708 21:52:56 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 709 21:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 710 21:52:56 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 430|0|0 711 21:52:56 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 712 21:52:56 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 713 21:52:56 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 714 21:52:56 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 715 21:52:56 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 716 21:52:56 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 717 21:52:56 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 718 21:52:56 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 719 21:52:56 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 720 21:52:56 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 721 21:52:56 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 722 21:52:56 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 723 21:52:56 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 724 21:52:56 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 725 21:52:56 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 726 21:52:56 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 727 21:52:56 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 728 21:52:56 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 729 21:52:56 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 730 21:52:56 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 93.12 731 21:52:56 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 732 21:52:56 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 733 21:52:56 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8 734 21:52:56 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 735 21:52:56 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 93.12 736 21:52:56 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 737 21:52:56 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 738 21:52:56 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 93.12 739 21:52:56 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 740 21:52:56 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 741 21:52:56 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 742 21:52:56 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32452 743 21:52:56 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 744 21:52:56 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 745 21:52:56 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 746 21:52:56 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 747 21:52:56 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 1|93.12|0.0 748 21:52:56 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0鈾|, 749 21:52:56 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 殀霄亅宾亅, 750 21:52:56 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 751 21:52:56 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 752 21:52:56 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 753 21:52:56 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 754 21:52:56 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32150 755 21:52:56 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 756 21:52:56 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 757 21:52:56 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 758 21:52:56 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 759 21:52:56 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 760 21:52:56 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 761 21:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 762 21:52:56 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 430|0|0 763 21:52:56 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 764 21:52:56 SQL Data In: ORACLE - Param = 3, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 765 21:52:56 SQL Data In: ORACLE - Param = 4, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 766 21:52:56 SQL Data In: ORACLE - Param = 5, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 767 21:52:56 SQL Data In: ORACLE - Param = 6, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 768 21:52:56 SQL Data In: ORACLE - Param = 7, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 769 21:52:56 SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 770 21:52:56 SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 771 21:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_KFB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_INJKCS => :P_INJKCS,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 772 21:52:56 SQL Execute: ORACLE - Commit 773 21:52:56 SQL Data In: ORACLE - Rows affected = 0 774 21:52:58 SQL Execute: ORACLE - Select SYSDATE from Dual 775 21:52:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 776 21:52:58 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') 777 21:52:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 ='0227494600010381' and ICKNBH ='0227494600010381' 778 21:52:58 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =127405 779 21:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 780 21:52:58 SQL Execute: ORACLE - select BRID00 FROM ic_yhxx00 where ickh00=? and ZT0000='1' 781 21:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 782 21:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 783 21:52:58 SQL Execute: ORACLE - select a.brid00,a.brxm00,a.brxb00,a.brblh0,a.mrn000,b.fbmc00,c.zye000,c.yktye0,d.yyid00,d.icguid,d.ickh00,d.kmh000 from BM_BRXXB0 A, BM_BRFBB0 B, SF_BRZHXX C ,IC_YHXX00 D where 1=1 and A.FBBH00 = B.FBBH00 and A.BRID00 = C.BRID00 and C.JFLBID=1 and A.BRID00 = D.BRID00 AND D.ICKH00=? and ZT0000='1' and A.BRID00=? 784 21:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 785 21:52:58 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00=? 786 21:52:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 787 21:52:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 788 21:52:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 789 21:52:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 790 21:52:59 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual 791 21:52:59 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='一卡通平台参数' order by XSXH00 792 21:52:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 793 21:52:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 794 21:52:59 SQL Execute: ORACLE - Select a.*,B.ICKH00,B.ICKNBH,B.KMH000,B.KLDH00,B.ICKSX0,B.ICGUID from bm_brxxb0 a,IC_YHXX00 B where A.BRID00=B.BRID00 AND a.brid00=? and B.ZT0000=? 795 21:52:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 796 21:52:59 SQL Execute: ORACLE - Select a.YGBH00,a.ZWXM00,a.XB0000,a.XKH000,nvl(a.BMBH00,0)BMBH00,a.YSZJHM from bm_ygbm00 a where a.YGBH00=? 797 21:52:59 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 798 21:52:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 799 21:52:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 800 21:52:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 801 21:52:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = SLE4442 802 21:52:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 803 21:52:59 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 804 21:52:59 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00010381 805 21:52:59 SQL Execute: ORACLE - select SF_SF_YKTCARDNO(?,?,?,?,?,?,?)CARDNO from dual 806 21:52:59 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 0|0|0 807 21:52:59 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 808 21:52:59 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 809 21:52:59 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 810 21:52:59 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 811 21:52:59 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 812 21:52:59 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 813 21:52:59 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 814 21:52:59 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 815 21:52:59 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 816 21:52:59 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 817 21:52:59 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 818 21:52:59 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 819 21:52:59 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 820 21:52:59 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 821 21:52:59 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 822 21:52:59 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 823 21:52:59 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 824 21:52:59 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 825 21:52:59 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 826 21:52:59 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 827 21:52:59 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 828 21:52:59 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 829 21:52:59 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 830 21:52:59 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 831 21:52:59 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 832 21:52:59 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 833 21:52:59 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 834 21:52:59 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 835 21:52:59 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 836 21:52:59 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 837 21:52:59 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 838 21:52:59 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 839 21:52:59 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 840 21:52:59 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 841 21:52:59 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 842 21:52:59 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 843 21:52:59 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 6, Scale = 0, Data = -1|0|0 844 21:52:59 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 14, Scale = 0, Data =   845 21:52:59 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 17, Scale = 0, Data = `纄誻緮褀[!詗 V 846 21:52:59 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 847 21:52:59 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 848 21:52:59 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 849 21:52:59 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 850 21:52:59 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32150 851 21:52:59 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 852 21:52:59 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 853 21:52:59 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 854 21:52:59 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 855 21:52:59 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 856 21:52:59 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 857 21:52:59 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 858 21:52:59 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 431|0|0 859 21:52:59 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 860 21:52:59 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 861 21:52:59 SQL Data In: ORACLE - Param = 4, Name = P_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 测试库 862 21:52:59 SQL Data In: ORACLE - Param = 5, Name = P_MKDM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 863 21:52:59 SQL Data In: ORACLE - Param = 6, Name = P_ICKH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0227494600010381 864 21:52:59 SQL Data In: ORACLE - Param = 7, Name = P_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 865 21:52:59 SQL Data In: ORACLE - Param = 8, Name = P_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 866 21:52:59 SQL Data In: ORACLE - Param = 9, Name = P_KZT000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 867 21:52:59 SQL Data In: ORACLE - Param = 10, Name = P_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 彭带弟 868 21:52:59 SQL Data In: ORACLE - Param = 11, Name = P_BRXB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 869 21:52:59 SQL Data In: ORACLE - Param = 12, Name = P_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19620101 870 21:52:59 SQL Data In: ORACLE - Param = 13, Name = P_LXDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 871 21:52:59 SQL Data In: ORACLE - Param = 14, Name = P_SFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 872 21:52:59 SQL Data In: ORACLE - Param = 15, Name = P_CSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 873 21:52:59 SQL Data In: ORACLE - Param = 16, Name = P_CZID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 874 21:52:59 SQL Data In: ORACLE - Param = 17, Name = P_JDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 875 21:52:59 SQL Data In: ORACLE - Param = 18, Name = P_JTZZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 876 21:52:59 SQL Data In: ORACLE - Param = 19, Name = P_ZJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 877 21:52:59 SQL Data In: ORACLE - Param = 20, Name = P_ZJHM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 878 21:52:59 SQL Data In: ORACLE - Param = 21, Name = P_YJJYE0, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 93.12 879 21:52:59 SQL Data In: ORACLE - Param = 22, Name = P_YJJYE1, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 880 21:52:59 SQL Data In: ORACLE - Param = 23, Name = P_XTDM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 881 21:52:59 SQL Data In: ORACLE - Param = 24, Name = P_JKMKDM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 882 21:52:59 SQL Data In: ORACLE - Param = 25, Name = P_XTCZBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 883 21:52:59 SQL Data In: ORACLE - Param = 26, Name = P_BGJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 884 21:52:59 SQL Data In: ORACLE - Param = 27, Name = P_BGBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 885 21:52:59 SQL Data In: ORACLE - Param = 28, Name = P_BGLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 886 21:52:59 SQL Data In: ORACLE - Param = 29, Name = P_BYKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 887 21:52:59 SQL Data In: ORACLE - Param = 30, Name = P_QTKFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 888 21:52:59 SQL Data In: ORACLE - Param = 31, Name = P_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 889 21:52:59 SQL Data In: ORACLE - Param = 32, Name = P_DJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 890 21:52:59 SQL Data In: ORACLE - Param = 33, Name = P_PTJYLS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 891 21:52:59 SQL Data In: ORACLE - Param = 34, Name = P_OLDKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 892 21:52:59 SQL Data In: ORACLE - Param = 35, Name = P_NEWKH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 893 21:52:59 SQL Data In: ORACLE - Param = 36, Name = P_ZFJE00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 894 21:52:59 SQL Data In: ORACLE - Param = 37, Name = P_YBZFJE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 895 21:52:59 SQL Data In: ORACLE - Param = 38, Name = P_INKZCS, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 1|93.12|0.0 896 21:52:59 SQL Data In: ORACLE - Param = 39, Name = P_PWARNMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 897 21:52:59 SQL Data In: ORACLE - Param = 40, Name = P_PERRMSG, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 898 21:52:59 SQL Data In: ORACLE - Param = 41, Name = P_JKFHZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 899 21:52:59 SQL Data In: ORACLE - Param = 42, Name = P_JKFHXX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 900 21:52:59 SQL Data In: ORACLE - Param = 43, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 901 21:52:59 SQL Data In: ORACLE - Param = 44, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 902 21:52:59 SQL Data In: ORACLE - Param = 45, Name = P_YKTBRID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 32150 903 21:52:59 SQL Data In: ORACLE - Param = 46, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 904 21:52:59 SQL Data In: ORACLE - Param = 47, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 905 21:52:59 SQL Data In: ORACLE - Param = 48, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 906 21:52:59 SQL Data In: ORACLE - Param = 49, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 907 21:52:59 SQL Data In: ORACLE - Param = 50, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 908 21:52:59 SQL Data In: ORACLE - Param = 51, Name = P_SSYYID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 227494 909 21:52:59 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_RZB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYXM0 => :P_CZYXM0,P_MKDM00 => :P_MKDM00,P_ICKH00 => :P_ICKH00,P_YBKH00 => :P_YBKH00,P_YBID00 => :P_YBID00,P_KZT000 => :P_KZT000,P_BRXM00 => :P_BRXM00,P_BRXB00 => :P_BRXB00,P_BRCSRQ => :P_BRCSRQ,P_LXDH00 => :P_LXDH00,P_SFID00 => :P_SFID00,P_CSID00 => :P_CSID00,P_CZID00 => :P_CZID00,P_JDID00 => :P_JDID00,P_JTZZ00 => :P_JTZZ00,P_ZJLX00 => :P_ZJLX00,P_ZJHM00 => :P_ZJHM00,P_YJJYE0 => :P_YJJYE0,P_YJJYE1 => :P_YJJYE1,P_XTDM00 => :P_XTDM00,P_JKMKDM => :P_JKMKDM,P_XTCZBZ => :P_XTCZBZ,P_BGJE00 => :P_BGJE00,P_BGBZ00 => :P_BGBZ00,P_BGLX00 => :P_BGLX00,P_BYKFJE => :P_BYKFJE,P_QTKFJE => :P_QTKFJE,P_YYID00 => :P_YYID00,P_DJH000 => :P_DJH000,P_PTJYLS => :P_PTJYLS,P_OLDKH0 => :P_OLDKH0,P_NEWKH0 => :P_NEWKH0,P_ZFJE00 => :P_ZFJE00,P_YBZFJE => :P_YBZFJE,P_INKZCS => :P_INKZCS,P_PWARNMSG => :P_PWARNMSG,P_PERRMSG => :P_PERRMSG,P_JKFHZT => :P_JKFHZT,P_JKFHXX => :P_JKFHXX,P_CZLX00 => :P_CZLX00,P_COMMIT => :P_COMMIT,P_YKTBRID => :P_YKTBRID,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,P_SSYYID => :P_SSYYID); END; 910 21:52:59 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 431|0|0 911 21:52:59 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127405.000000 912 21:52:59 SQL Data In: ORACLE - Param = 3, Name = P_INJKCS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 913 21:52:59 SQL Data In: ORACLE - Param = 4, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 914 21:52:59 SQL Data In: ORACLE - Param = 5, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 915 21:52:59 SQL Data In: ORACLE - Param = 6, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 916 21:52:59 SQL Data In: ORACLE - Param = 7, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 917 21:52:59 SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 918 21:52:59 SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 919 21:52:59 SQL Execute: ORACLE - BEGIN "SP_SF_HIS_YKT_KFB" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_INJKCS => :P_INJKCS,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 920 21:52:59 SQL Execute: ORACLE - Commit 921 21:52:59 SQL Data In: ORACLE - Rows affected = 0 922 21:53:04 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 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',24,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '24') AND (INSTR (',' || a.jsksbh || ',',',24,') > 0 or a.jsksbh is null)