1 15:02:30 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 =316 and SYBZ00 = 'Y' 2 15:02:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 3 15:02:30 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 4 15:02:30 SQL Execute: ORACLE - update BM_BRXXB0 set TYDWMC='福州市劳务派遣有限公司',BRXB00='男',BRMZ00='汉族',BRLXXM='',BRJTDZ='福建省',BRXZDZ='',BRZJBH='',BRLXDH='',BRSZSF='福建省',BRSZS0='',BRSZZ0='',BRSZC0='',BRXZSF='',BRXZS0='',BRXZZ0='',BRXZC0='',BRZJLX='身份证' ,TSSXMC='普通' where BRID00=403096 5 15:02:30 SQL Data In: ORACLE - Rows affected = 1 6 15:02:30 SQL Execute: ORACLE - commit 7 15:02:30 SQL Data In: ORACLE - Rows affected = 0 8 15:02:30 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 403096.000000 9 15:02:30 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 130110 10 15:02:30 SQL Data In: ORACLE - Param = 3, Name = AS_ZYH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 130110 11 15:02:30 SQL Data In: ORACLE - Param = 4, Name = AS_YBZYH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 12 15:02:30 SQL Data In: ORACLE - Param = 5, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 严熙 13 15:02:30 SQL Data In: ORACLE - Param = 6, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 14 15:02:30 SQL Data In: ORACLE - Param = 7, Name = AS_CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19810402 15 15:02:30 SQL Data In: ORACLE - Param = 8, Name = AD_FBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 16 15:02:30 SQL Data In: ORACLE - Param = 9, Name = AS_RYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160513 17 15:02:30 SQL Data In: ORACLE - Param = 10, Name = AS_RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:02:15 18 15:02:30 SQL Data In: ORACLE - Param = 11, Name = AD_RYCZY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 316.000000 19 15:02:30 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈 梅 20 15:02:30 SQL Data In: ORACLE - Param = 13, Name = AS_RYZD00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 21 15:02:30 SQL Data In: ORACLE - Param = 14, Name = AS_RYSQK0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 15:02:30 SQL Data In: ORACLE - Param = 15, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 23 15:02:30 SQL Data In: ORACLE - Param = 16, Name = AS_RYBQMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 内科一区 24 15:02:30 SQL Data In: ORACLE - Param = 17, Name = AS_RZKSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 内科住院 25 15:02:30 SQL Data In: ORACLE - Param = 18, Name = AS_RYCWH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 15:02:30 SQL Data In: ORACLE - Param = 19, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 27 15:02:30 SQL Data In: ORACLE - Param = 20, Name = AD_ZZYS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 15:02:30 SQL Data In: ORACLE - Param = 21, Name = AS_ZZYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 29 15:02:30 SQL Data In: ORACLE - Param = 22, Name = AD_ZRYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 30 15:02:30 SQL Data In: ORACLE - Param = 23, Name = AS_ZRYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 31 15:02:30 SQL Data In: ORACLE - Param = 24, Name = AD_SXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 32 15:02:30 SQL Data In: ORACLE - Param = 25, Name = AS_SXYSXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 15:02:30 SQL Data In: ORACLE - Param = 26, Name = AS_JFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 15:02:30 SQL Data In: ORACLE - Param = 27, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 住院预交金 35 15:02:30 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000 36 15:02:30 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 37 15:02:30 SQL Data In: ORACLE - Param = 30, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 38 15:02:30 SQL Data In: ORACLE - Param = 31, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 39 15:02:30 SQL Data In: ORACLE - Param = 32, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 15:02:30 SQL Data In: ORACLE - Param = 33, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 41 15:02:30 SQL Data In: ORACLE - Param = 34, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0036451 42 15:02:30 SQL Data In: ORACLE - Param = 35, Name = AS_BRRYCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 43 15:02:30 SQL Data In: ORACLE - Param = 36, Name = AD_YZCS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 44 15:02:30 SQL Data In: ORACLE - Param = 37, Name = AD_YZYBJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 45 15:02:30 SQL Data In: ORACLE - Param = 38, Name = AD_SZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 46 15:02:30 SQL Data In: ORACLE - Param = 39, Name = AS_RYZDMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 47 15:02:30 SQL Data In: ORACLE - Param = 40, Name = AS_YBZFRY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 48 15:02:30 SQL Data In: ORACLE - Param = 41, Name = AD_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 49 15:02:30 SQL Data In: ORACLE - Param = 42, Name = AD_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国 50 15:02:30 SQL Data In: ORACLE - Param = 43, Name = AD_TBZX00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 非医保 51 15:02:30 SQL Data In: ORACLE - Param = 44, Name = AD_ZJHM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 52 15:02:30 SQL Data In: ORACLE - Param = 45, Name = AD_DWMC00, Type = fldZSTRING, Precision = 22, Scale = 0, Data = 福州市劳务派遣有限公司 53 15:02:30 SQL Data In: ORACLE - Param = 46, Name = AD_LXR000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 54 15:02:30 SQL Data In: ORACLE - Param = 47, Name = AD_BRLXDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 55 15:02:30 SQL Data In: ORACLE - Param = 48, Name = AD_BRJTDZ, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 56 15:02:30 SQL Data In: ORACLE - Param = 49, Name = AS_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 15:02:30 SQL Data In: ORACLE - Param = 50, Name = as_BRZTQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 15:02:30 SQL Data In: ORACLE - Param = 51, Name = ad_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 15:02:30 SQL Data In: ORACLE - Param = 52, Name = ad_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 60 15:02:30 SQL Data In: ORACLE - Param = 53, Name = as_YBLB00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 非医保 61 15:02:30 SQL Data In: ORACLE - Param = 54, Name = as_BRRYTJ, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 门诊 62 15:02:30 SQL Data In: ORACLE - Param = 55, Name = as_BRZLLB, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 中西医 63 15:02:30 SQL Data In: ORACLE - Param = 56, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 15:02:30 SQL Data In: ORACLE - Param = 57, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 65 15:02:30 SQL Data In: ORACLE - Param = 58, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 66 15:02:30 SQL Data In: ORACLE - Param = 59, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 67 15:02:30 SQL Data In: ORACLE - Param = 60, Name = ad_ZJXXLY, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 15:02:30 SQL Execute: ORACLE - BEGIN "SP_ZY_BRRYDJ" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_ZYH000 => :AS_ZYH000,AS_YBZYH0 => :AS_YBZYH0,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AS_CSRQ00 => :AS_CSRQ00,AD_FBBH00 => :AD_FBBH00,AS_RYRQ00 => :AS_RYRQ00,AS_RYSJ00 => :AS_RYSJ00,AD_RYCZY0 => :AD_RYCZY0,AS_CZYXM0 => :AS_CZYXM0,AS_RYZD00 => :AS_RYZD00,AS_RYSQK0 => :AS_RYSQK0,AS_RYLB00 => :AS_RYLB00,AS_RYBQMC => :AS_RYBQMC,AS_RZKSMC => :AS_RZKSMC,AS_RYCWH0 => :AS_RYCWH0,AS_BRZT00 => :AS_BRZT00,AD_ZZYS00 => :AD_ZZYS00,AS_ZZYSXM => :AS_ZZYSXM,AD_ZRYS00 => :AD_ZRYS00,AS_ZRYSXM => :AS_ZRYSXM,AD_SXYS00 => :AD_SXYS00,AS_SXYSXM => :AS_SXYSXM,AS_JFBZ00 => :AS_JFBZ00,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_BRRYCS => :AS_BRRYCS,AD_YZCS00 => :AD_YZCS00,AD_YZYBJE => :AD_YZYBJE,AD_SZYS00 => :AD_SZYS00,AS_RYZDMC => :AS_RYZDMC,AS_YBZFRY => :AS_YBZFRY,AD_BRMZ00 => :AD_BRMZ00,AD_BRGJ00 => :AD_BRGJ00,AD_TBZX00 => :AD_TBZX00,AD_ZJHM00 => :AD_ZJHM00,AD_DWMC00 => :AD_DWMC00,AD_LXR000 => :AD_LXR000,AD_BRLXDH => :AD_BRLXDH,AD_BRJTDZ => :AD_BRJTDZ,AS_GSDJH0 => :AS_GSDJH0,as_BRZTQK => :as_BRZTQK,ad_DBLB00 => :ad_DBLB00,ad_DBLBMC => :ad_DBLBMC,as_YBLB00 => :as_YBLB00,as_BRRYTJ => :as_BRRYTJ,as_BRZLLB => :as_BRZLLB,AD_ZYID00 => :AD_ZYID00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_ZJXXLY => :ad_ZJXXLY); END; 69 15:02:30 SQL Execute: ORACLE - RollBack 70 15:02:30 SQL Data In: ORACLE - Rows affected = 0