1 15:49:55 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 2 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 3 15:49:55 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 4 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 5 15:49:55 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 6 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 7 15:49:55 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 8 15:49:55 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 9 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0009 10 15:49:55 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 11 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 12 15:49:55 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 13 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 14 15:49:55 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,b.FBBH00 from bm_brxxb0 a,ZY_BRXXB0 B where A.BRID00=B.BRID00 and b.zyid00=? 15 15:49:55 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 16 15:49:55 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20211025154955677555317','新医保接口','N3286369104931921089708686429H3354110635212719470725211X病人入院取消普通易联众01') 17 15:49:55 SQL Data In: ORACLE - Rows affected = 1 18 15:49:55 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0009 19 15:49:55 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 20 15:49:55 SQL Data In: ORACLE - Param = 3, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 21 15:49:55 SQL Data In: ORACLE - Param = 4, Name = PZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2108970 22 15:49:55 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 23 15:49:55 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 24 15:49:55 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 25 15:49:55 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025154955677555317 26 15:49:55 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 27 15:49:55 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 28 15:49:55 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 29 15:49:55 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 15:49:55 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 15:49:55 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 32 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 33 15:49:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 34 15:49:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 35 15:49:55 SQL Execute: ORACLE - update ZY_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 36 15:49:55 SQL Data In: ORACLE - Rows affected = 1 37 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 38 15:49:55 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from ZY_YBJKMX where YBJKID=? and ZJDBM0='data' 39 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 40 15:49:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 41 15:49:55 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 42 15:49:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 43 15:49:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 44 15:49:55 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 45 15:49:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 46 15:49:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 47 15:49:57 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 48 15:49:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 49 15:49:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 50 15:49:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 51 15:49:57 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 52 15:49:57 SQL Data In: ORACLE - Rows affected = 1 53 15:49:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 54 15:49:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 55 15:49:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 56 15:49:57 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 57 15:49:57 SQL Data In: ORACLE - Rows affected = 1 58 15:49:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 59 15:49:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 60 15:49:57 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 61 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8686429 62 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 63 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc190 64 15:49:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 65 15:49:58 SQL Data In: ORACLE - Rows affected = 1 66 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 67 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 68 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 69 15:49:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 70 15:49:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 72, Scale = 0, Data = {"traceid":"","flag":"1","data":{"akc190":"8686429"},"cause":"操作成功"} 71 15:49:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 72 15:49:58 SQL Execute: ORACLE - update zy_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 73 15:49:58 SQL Data In: ORACLE - Rows affected = 1 74 15:49:58 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 75 15:49:58 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0009 76 15:49:58 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 77 15:49:58 SQL Data In: ORACLE - Param = 4, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 78 15:49:58 SQL Data In: ORACLE - Param = 5, Name = PZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2108970 79 15:49:58 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 80 15:49:58 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 81 15:49:58 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 82 15:49:58 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025154955677555317 83 15:49:58 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 15:49:58 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 85 15:49:58 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 86 15:49:58 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 87 15:49:58 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 88 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 89 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_YBJKRZ where YBJKID=? 90 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 91 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc054 92 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 93 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 94 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 95 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae072 96 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 97 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 98 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 99 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 100 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 101 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 102 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 103 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007 104 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 105 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 106 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 107 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029 108 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 109 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 110 15:49:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135889 111 15:49:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 112 15:49:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 113 15:49:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 114 15:49:58 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 115 15:49:58 SQL Data In: ORACLE - Param = 2, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 116 15:49:58 SQL Data In: ORACLE - Param = 3, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 117 15:49:58 SQL Data In: ORACLE - Param = 4, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 118 15:49:58 SQL Data In: ORACLE - Param = 5, Name = AS_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 119 15:49:58 SQL Data In: ORACLE - Param = 6, Name = AS_YBLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 120 15:49:58 SQL Data In: ORACLE - Param = 7, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 121 15:49:58 SQL Data In: ORACLE - Param = 8, Name = AS_BCKBCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 122 15:49:58 SQL Data In: ORACLE - Param = 9, Name = AS_ZYLSH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 123 15:49:58 SQL Data In: ORACLE - Param = 10, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈贤柱 124 15:49:58 SQL Data In: ORACLE - Param = 11, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 125 15:49:58 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 126 15:49:58 SQL Data In: ORACLE - Param = 13, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 127 15:49:58 SQL Data In: ORACLE - Param = 14, Name = AS_TSBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 128 15:49:58 SQL Data In: ORACLE - Param = 15, Name = AS_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 129 15:49:58 SQL Data In: ORACLE - Param = 16, Name = AS_CSLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 130 15:49:58 SQL Data In: ORACLE - Param = 17, Name = AS_DWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 15:49:58 SQL Data In: ORACLE - Param = 18, Name = AS_XZQH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 132 15:49:58 SQL Data In: ORACLE - Param = 19, Name = AS_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 133 15:49:58 SQL Data In: ORACLE - Param = 20, Name = AS_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 134 15:49:58 SQL Data In: ORACLE - Param = 21, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 15:49:58 SQL Data In: ORACLE - Param = 22, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 136 15:49:58 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 137 15:49:58 SQL Data In: ORACLE - Param = 24, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 138 15:49:58 SQL Data In: ORACLE - Param = 25, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 139 15:49:58 SQL Data In: ORACLE - Param = 26, Name = AS_ICZTMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 140 15:49:58 SQL Data In: ORACLE - Param = 27, Name = AS_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 141 15:49:58 SQL Data In: ORACLE - Param = 28, Name = AS_GRZHYE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 142 15:49:58 SQL Data In: ORACLE - Param = 29, Name = AS_SFRZLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 143 15:49:58 SQL Execute: ORACLE - BEGIN "SP_ZY_BRFB00_EDIT00" (AD_BRID00 => :AD_BRID00,AD_ZYID00 => :AD_ZYID00,AS_FBMC00 => :AS_FBMC00,AS_YBKH00 => :AS_YBKH00,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_BRZTQK => :AS_BRZTQK,AS_BCKBCS => :AS_BCKBCS,AS_ZYLSH0 => :AS_ZYLSH0,AS_XM0000 => :AS_XM0000,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_RYLB00 => :AS_RYLB00,AS_TSBZ00 => :AS_TSBZ00,AS_GSDJH0 => :AS_GSDJH0,AS_CSLX00 => :AS_CSLX00,AS_DWMC00 => :AS_DWMC00,AS_XZQH00 => :AS_XZQH00,AS_DBLB00 => :AS_DBLB00,AS_DBLBMC => :AS_DBLBMC,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZXCGBZ => :PZXCGBZ,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,AS_ICZTMC => :AS_ICZTMC,AS_SFJZFP => :AS_SFJZFP,AS_GRZHYE => :AS_GRZHYE,AS_SFRZLX => :AS_SFRZLX); END; 144 15:49:58 SQL Execute: ORACLE - Commit 145 15:49:58 SQL Data In: ORACLE - Rows affected = 0 146 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 1049319.00 147 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 1049319.00 148 15:49:58 SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 1049319.00 and JZDH00+0 = 0 and CZRQ00 <= '20211025' order by MXID00 149 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 1049319.00 and KDRQ00 <= '20211025' order by SFYP00,ZXKSBH,XMBH00 150 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 1049319.00 and PLBH00 in (4,8) order by DJH000 151 15:49:58 SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 1049319.00 order by JZDH00 152 15:49:59 SQL Execute: ORACLE - select * from VW_ZY_FBXGRZ where ZYID00 = 1049319.00 order by CZRQ00,CZSJ00 153 15:49:59 SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where BRID00 = 3286369.00 154 15:49:59 SQL Execute: ORACLE - select max(JZRQ00) from zy_jzb000 where zyid00=1049319.00 and JSLX00='3' and JZZT00='0' and HJJE00>0 155 15:49:59 SQL Execute: ORACLE - select YBBRLB,BRLBMC,BRLBJC,YBZXLB,FBBH00,MZYBZF,YBZFBL,YBQFBZ,SFMLXZ,ZYZFSX,MZZFSX,YJFDBL,YJFDSX from BM_YBBRLB where FBBH00=-1 order by FBBH00,YBZXLB,YBBRLB 156 15:49:59 SQL Execute: ORACLE - select YBLB00,YBMC00,YBZXLB,FBBH00,YBBHSB,SFXNH0,YBJGJC,CSLX00,XZQH00,JSDWBH from IC_YBBRLB where FBBH00=-1 order by FBBH00,YBZXLB,PXH000,YBLB00 157 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 158 15:52:47 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual 159 15:52:47 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 160 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 161 15:52:47 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 162 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 163 15:52:47 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 164 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 165 15:52:47 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 166 15:52:47 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 167 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005 168 15:52:47 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 169 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 170 15:52:47 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 171 15:52:47 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 172 15:52:47 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20211025155247862555343','新医保接口','YH33541106陈贤柱3286369住院病人住院登记_刷卡易联众35212719470725211X01') 173 15:52:47 SQL Data In: ORACLE - Rows affected = 1 174 15:52:47 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005 175 15:52:47 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 176 15:52:47 SQL Data In: ORACLE - Param = 3, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 177 15:52:47 SQL Data In: ORACLE - Param = 4, Name = PZYH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 178 15:52:47 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 179 15:52:47 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 180 15:52:47 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 181 15:52:47 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025155247862555343 182 15:52:47 SQL Data In: ORACLE - Param = 9, Name = PINCS00, Type = fldZSTRING, Precision = 240, Scale = 0, Data = YH33541106陈贤柱3286369住院病人住院登记_刷卡易联众35212719470725211X01 183 15:52:47 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 21, Scale = 0, Data = 住院病人住院登记_刷卡 184 15:52:47 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 185 15:52:47 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 186 15:52:47 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 187 15:52:47 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 188 15:52:47 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 189 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 190 15:52:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 191 15:52:47 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 192 15:52:47 SQL Execute: ORACLE - update ZY_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 193 15:52:47 SQL Data In: ORACLE - Rows affected = 1 194 15:52:47 SQL Execute: ORACLE - COMMIT 195 15:52:47 SQL Data In: ORACLE - Rows affected = 0 196 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 197 15:52:47 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from ZY_YBJKMX where YBJKID=? and ZJDBM0='data' 198 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 199 15:52:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 200 15:52:47 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 201 15:52:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 202 15:52:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 203 15:52:47 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 204 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 205 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 206 15:52:50 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 207 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 208 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 209 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 210 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 211 15:52:50 SQL Data In: ORACLE - Rows affected = 1 212 15:52:50 SQL Execute: ORACLE - COMMIT 213 15:52:50 SQL Data In: ORACLE - Rows affected = 0 214 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 215 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 216 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 217 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 218 15:52:50 SQL Data In: ORACLE - Rows affected = 1 219 15:52:50 SQL Execute: ORACLE - COMMIT 220 15:52:50 SQL Data In: ORACLE - Rows affected = 0 221 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 222 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 223 15:52:50 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 224 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 225 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 226 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac058 227 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 228 15:52:50 SQL Data In: ORACLE - Rows affected = 1 229 15:52:50 SQL Execute: ORACLE - COMMIT 230 15:52:50 SQL Data In: ORACLE - Rows affected = 0 231 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 居民身份证（户口簿） 232 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 233 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aac058_mc 234 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 235 15:52:50 SQL Data In: ORACLE - Rows affected = 1 236 15:52:50 SQL Execute: ORACLE - COMMIT 237 15:52:50 SQL Data In: ORACLE - Rows affected = 0 238 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 239 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 240 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac999 241 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 242 15:52:50 SQL Data In: ORACLE - Rows affected = 1 243 15:52:50 SQL Execute: ORACLE - COMMIT 244 15:52:50 SQL Data In: ORACLE - Rows affected = 0 245 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2302 246 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 247 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka162 248 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 249 15:52:50 SQL Data In: ORACLE - Rows affected = 1 250 15:52:50 SQL Execute: ORACLE - COMMIT 251 15:52:50 SQL Data In: ORACLE - Rows affected = 0 252 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 建档立卡的贫困人口 253 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 254 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = bka162_mc 255 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 256 15:52:50 SQL Data In: ORACLE - Rows affected = 1 257 15:52:50 SQL Execute: ORACLE - COMMIT 258 15:52:50 SQL Data In: ORACLE - Rows affected = 0 259 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H33541106 260 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 261 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz500 262 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 263 15:52:50 SQL Data In: ORACLE - Rows affected = 1 264 15:52:50 SQL Execute: ORACLE - COMMIT 265 15:52:50 SQL Data In: ORACLE - Rows affected = 0 266 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 267 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 268 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac002 269 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 270 15:52:50 SQL Data In: ORACLE - Rows affected = 1 271 15:52:50 SQL Execute: ORACLE - COMMIT 272 15:52:50 SQL Data In: ORACLE - Rows affected = 0 273 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈贤柱 274 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 275 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac003 276 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 277 15:52:50 SQL Data In: ORACLE - Rows affected = 1 278 15:52:50 SQL Execute: ORACLE - COMMIT 279 15:52:50 SQL Data In: ORACLE - Rows affected = 0 280 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19470725 281 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 282 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac006 283 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 284 15:52:50 SQL Data In: ORACLE - Rows affected = 1 285 15:52:50 SQL Execute: ORACLE - COMMIT 286 15:52:50 SQL Data In: ORACLE - Rows affected = 0 287 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 288 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 289 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac004 290 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 291 15:52:50 SQL Data In: ORACLE - Rows affected = 1 292 15:52:50 SQL Execute: ORACLE - COMMIT 293 15:52:50 SQL Data In: ORACLE - Rows affected = 0 294 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 295 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 296 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aac004_mc 297 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 298 15:52:50 SQL Data In: ORACLE - Rows affected = 1 299 15:52:50 SQL Execute: ORACLE - COMMIT 300 15:52:50 SQL Data In: ORACLE - Rows affected = 0 301 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350723 302 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 303 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab034 304 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 305 15:52:50 SQL Data In: ORACLE - Rows affected = 1 306 15:52:50 SQL Execute: ORACLE - COMMIT 307 15:52:50 SQL Data In: ORACLE - Rows affected = 0 308 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 36, Scale = 0, Data = 南平市医疗保障基金管理中心光泽管理部 309 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 310 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aab034_mc 311 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 312 15:52:50 SQL Data In: ORACLE - Rows affected = 1 313 15:52:50 SQL Execute: ORACLE - COMMIT 314 15:52:50 SQL Data In: ORACLE - Rows affected = 0 315 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350723 316 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 317 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab301 318 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 319 15:52:50 SQL Data In: ORACLE - Rows affected = 1 320 15:52:50 SQL Execute: ORACLE - COMMIT 321 15:52:50 SQL Data In: ORACLE - Rows affected = 0 322 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 光泽县 323 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 324 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aab301_mc 325 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 326 15:52:50 SQL Data In: ORACLE - Rows affected = 1 327 15:52:50 SQL Execute: ORACLE - COMMIT 328 15:52:50 SQL Data In: ORACLE - Rows affected = 0 329 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 330 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 331 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc087 332 15:52:50 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 333 15:52:50 SQL Data In: ORACLE - Rows affected = 1 334 15:52:50 SQL Execute: ORACLE - COMMIT 335 15:52:50 SQL Data In: ORACLE - Rows affected = 0 336 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 337 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 338 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 339 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 340 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 身份标志 341 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 342 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 343 15:52:50 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 76, Scale = 0, Data = 是否扶贫对象YBKA531 344 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 345 15:52:50 SQL Data In: ORACLE - Rows affected = 1 346 15:52:50 SQL Execute: ORACLE - COMMIT 347 15:52:50 SQL Data In: ORACLE - Rows affected = 0 348 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 349 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 350 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 351 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 352 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 身份标志 353 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 354 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 355 15:52:50 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 80, Scale = 0, Data = 是否医疗救助对象Ybka544 356 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 357 15:52:50 SQL Data In: ORACLE - Rows affected = 1 358 15:52:50 SQL Execute: ORACLE - COMMIT 359 15:52:50 SQL Data In: ORACLE - Rows affected = 0 360 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 361 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 362 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 363 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist 364 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 身份标志 365 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 366 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 367 15:52:50 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 76, Scale = 0, Data = 是否保健对象NBKA547 368 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 369 15:52:50 SQL Data In: ORACLE - Rows affected = 1 370 15:52:50 SQL Execute: ORACLE - COMMIT 371 15:52:50 SQL Data In: ORACLE - Rows affected = 0 372 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 373 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 374 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = cbxzlist 375 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = cbxzlist 376 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 参保险种 377 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 378 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 379 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 380 15:52:50 SQL Data In: ORACLE - Rows affected = 1 381 15:52:50 SQL Execute: ORACLE - COMMIT 382 15:52:50 SQL Data In: ORACLE - Rows affected = 0 383 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 384 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 385 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = tmdjlist 386 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = tmdjlist 387 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 特殊病种登记信息 388 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 389 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 390 15:52:50 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 198, Scale = 0, Data = 0000060000139999123120200724高血压(I期) 391 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 392 15:52:50 SQL Data In: ORACLE - Rows affected = 1 393 15:52:50 SQL Execute: ORACLE - COMMIT 394 15:52:50 SQL Data In: ORACLE - Rows affected = 0 395 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 396 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 397 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = tmdjlist 398 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = tmdjlist 399 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 特殊病种登记信息 400 15:52:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 401 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 402 15:52:50 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 192, Scale = 0, Data = M039129999123120200724高血压(I期) 403 15:52:50 SQL Execute: ORACLE - insert into ZY_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 404 15:52:50 SQL Data In: ORACLE - Rows affected = 1 405 15:52:50 SQL Execute: ORACLE - COMMIT 406 15:52:50 SQL Data In: ORACLE - Rows affected = 0 407 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 408 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 409 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 410 15:52:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 411 15:52:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 183, Scale = 0, Data = {"usr":"npjgsqm0501","pwd":"7950567@Gzxyy","funid":"yb04.10.01.17","data":{"bke284":"01","aaz501":"","bkz543":"","aaz500":"H33541106","aac002":"35212719470725211X","aac003":"陈贤柱"}} 412 15:52:50 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 413 15:52:50 SQL Execute: ORACLE - update zy_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 414 15:52:50 SQL Data In: ORACLE - Rows affected = 1 415 15:52:50 SQL Execute: ORACLE - COMMIT 416 15:52:50 SQL Data In: ORACLE - Rows affected = 0 417 15:52:50 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 418 15:52:50 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005 419 15:52:50 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 420 15:52:50 SQL Data In: ORACLE - Param = 4, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 421 15:52:50 SQL Data In: ORACLE - Param = 5, Name = PZYH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 422 15:52:50 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 423 15:52:50 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 424 15:52:50 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 425 15:52:50 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025155247862555343 426 15:52:50 SQL Data In: ORACLE - Param = 10, Name = PINCS00, Type = fldZSTRING, Precision = 240, Scale = 0, Data = YH33541106陈贤柱3286369住院病人住院登记_刷卡易联众35212719470725211X01 427 15:52:50 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 21, Scale = 0, Data = 住院病人住院登记_刷卡 428 15:52:50 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 429 15:52:50 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 430 15:52:50 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 431 15:52:50 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 432 15:52:50 SQL Execute: ORACLE - COMMIT 433 15:52:50 SQL Data In: ORACLE - Rows affected = 0 434 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 435 15:52:50 SQL Execute: ORACLE - select * from VW_ZY_YBJKRZ where YBJKID=? 436 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 437 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc054 438 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 439 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 440 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 441 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc190 442 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 443 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 444 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 445 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae072 446 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 447 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 448 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 449 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 450 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 451 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 452 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 453 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007 454 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 455 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 456 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 457 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029 458 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 459 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 460 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 461 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 462 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 463 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 464 15:52:50 SQL Execute: ORACLE - update BM_BRXXB0 set BRZTQK = '城乡居民' where BRID00 = 3286369.00 465 15:52:50 SQL Data In: ORACLE - Rows affected = 1 466 15:52:50 SQL Execute: ORACLE - commit 467 15:52:50 SQL Data In: ORACLE - Rows affected = 0 468 15:52:50 SQL Execute: ORACLE - select YBMC00 from IC_YBBRLB where SFYX00='1' and trim(XZQH00) = '350723' 469 15:52:50 SQL Execute: ORACLE - select a.SFXNH0 from IC_YBBRLB a where a.YBMC00 = '南平市医疗保障基金管理中心光泽管理部' 470 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 36, Scale = 0, Data = 南平市医疗保障基金管理中心光泽管理部 471 15:52:50 SQL Execute: ORACLE - select trim(RYLBBZ) RYLBBZ from IC_YBBRLB a where YBMC00 = ? 472 15:52:50 SQL Execute: ORACLE - select a.SFXNH0 from IC_YBBRLB a where a.YBMC00 = '南平市医疗保障基金管理中心光泽管理部' 473 15:52:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135894 474 15:52:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 475 15:52:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 476 15:52:50 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 477 15:52:54 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='不孕症诊断字典' and YXBZ00='1' and BH0000='' 478 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 36, Scale = 0, Data = 南平市医疗保障基金管理中心光泽管理部 479 15:52:55 SQL Execute: ORACLE - select YBLB00 from IC_YBBRLB where YBMC00=? and FBBH00=3 480 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1049319 481 15:52:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 482 15:52:55 SQL Execute: ORACLE - select SF_ZY_GetYYKSBM(?,0,?,3) from dual 483 15:52:55 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 484 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 485 15:52:55 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 486 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 487 15:52:55 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 488 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 489 15:52:55 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 490 15:52:55 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 491 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0007 492 15:52:55 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 493 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 494 15:52:55 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 495 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 496 15:52:55 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,b.FBBH00 from bm_brxxb0 a,ZY_BRXXB0 B where A.BRID00=B.BRID00 and b.zyid00=? 497 15:52:55 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 498 15:52:55 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20211025155255726555347','新医保接口','N3286369104931921089702021102515:44:34普通1144海泰测试科室H33541106易联众医保入院登记35212719470725211X01114435212719470725211X') 499 15:52:55 SQL Data In: ORACLE - Rows affected = 1 500 15:52:55 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0007 501 15:52:55 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 502 15:52:55 SQL Data In: ORACLE - Param = 3, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 503 15:52:55 SQL Data In: ORACLE - Param = 4, Name = PZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2108970 504 15:52:55 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 505 15:52:55 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 506 15:52:55 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 507 15:52:55 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025155255726555347 508 15:52:55 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 509 15:52:55 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 510 15:52:55 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 511 15:52:55 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 512 15:52:55 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 513 15:52:55 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 514 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 515 15:52:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 516 15:52:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 517 15:52:55 SQL Execute: ORACLE - update ZY_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 518 15:52:55 SQL Data In: ORACLE - Rows affected = 1 519 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 520 15:52:55 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from ZY_YBJKMX where YBJKID=? and ZJDBM0='data' 521 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 522 15:52:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 523 15:52:55 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 524 15:52:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 525 15:52:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 526 15:52:55 SQL Execute: ORACLE - select * from ZY_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 527 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 528 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 529 15:52:58 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 530 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 531 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 532 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 533 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 534 15:52:58 SQL Data In: ORACLE - Rows affected = 1 535 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 536 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 537 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 538 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 539 15:52:58 SQL Data In: ORACLE - Rows affected = 1 540 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 541 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 542 15:52:58 SQL Execute: ORACLE - Select * from zy_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 543 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 21 544 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 545 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka130 546 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 547 15:52:58 SQL Data In: ORACLE - Rows affected = 1 548 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 549 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 550 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkf009 551 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 552 15:52:58 SQL Data In: ORACLE - Rows affected = 1 553 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 554 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 555 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka078 556 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 557 15:52:58 SQL Data In: ORACLE - Rows affected = 1 558 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 559 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 560 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akb023 561 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 562 15:52:58 SQL Data In: ORACLE - Rows affected = 1 563 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 定点医疗机构 564 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 565 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = akb023_mc 566 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 567 15:52:58 SQL Data In: ORACLE - Rows affected = 1 568 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 569 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 570 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac999 571 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 572 15:52:58 SQL Data In: ORACLE - Rows affected = 1 573 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2302 574 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 575 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka162 576 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 577 15:52:58 SQL Data In: ORACLE - Rows affected = 1 578 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 建档立卡的贫困人口 579 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 580 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = bka162_mc 581 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 582 15:52:58 SQL Data In: ORACLE - Rows affected = 1 583 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 584 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 585 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = bke174_mc 586 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 587 15:52:58 SQL Data In: ORACLE - Rows affected = 1 588 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H33541106 589 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 590 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz500 591 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 592 15:52:58 SQL Data In: ORACLE - Rows affected = 1 593 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 594 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 595 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac002 596 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 597 15:52:58 SQL Data In: ORACLE - Rows affected = 1 598 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈贤柱 599 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 600 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac003 601 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 602 15:52:58 SQL Data In: ORACLE - Rows affected = 1 603 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19470725 604 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 605 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac006 606 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 607 15:52:58 SQL Data In: ORACLE - Rows affected = 1 608 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 609 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 610 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac004 611 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 612 15:52:58 SQL Data In: ORACLE - Rows affected = 1 613 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 614 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 615 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aac004_mc 616 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 617 15:52:58 SQL Data In: ORACLE - Rows affected = 1 618 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350723 619 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 620 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab034 621 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 622 15:52:58 SQL Data In: ORACLE - Rows affected = 1 623 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 36, Scale = 0, Data = 南平市医疗保障基金管理中心光泽管理部 624 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 625 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aab034_mc 626 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 627 15:52:58 SQL Data In: ORACLE - Rows affected = 1 628 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350723 629 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 630 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab301 631 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 632 15:52:58 SQL Data In: ORACLE - Rows affected = 1 633 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 390 634 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 635 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae140 636 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 637 15:52:58 SQL Data In: ORACLE - Rows affected = 1 638 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 城乡居民基本医疗保险 639 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 640 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aae140_mc 641 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 642 15:52:58 SQL Data In: ORACLE - Rows affected = 1 643 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 156001 644 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 645 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc001 646 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 647 15:52:58 SQL Data In: ORACLE - Rows affected = 1 648 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 城乡居民 649 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 650 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = bkc001_mc 651 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 652 15:52:58 SQL Data In: ORACLE - Rows affected = 1 653 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 654 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 655 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc026 656 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 657 15:52:58 SQL Data In: ORACLE - Rows affected = 1 658 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 659 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 660 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = bkc026_mc 661 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 662 15:52:58 SQL Data In: ORACLE - Rows affected = 1 663 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8690259 664 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 665 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc190 666 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 667 15:52:58 SQL Data In: ORACLE - Rows affected = 1 668 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 669 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 670 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke174 671 15:52:58 SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 672 15:52:58 SQL Data In: ORACLE - Rows affected = 1 673 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 674 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 675 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 676 15:52:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 677 15:52:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 678 15:52:58 SQL Execute: ORACLE - update zy_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 679 15:52:58 SQL Data In: ORACLE - Rows affected = 1 680 15:52:58 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 681 15:52:58 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_ZYDJ_0007 682 15:52:58 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 683 15:52:58 SQL Data In: ORACLE - Param = 4, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 684 15:52:58 SQL Data In: ORACLE - Param = 5, Name = PZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2108970 685 15:52:58 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 686 15:52:58 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 687 15:52:58 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 688 15:52:58 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211025155255726555347 689 15:52:58 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 690 15:52:58 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 691 15:52:58 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 692 15:52:58 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 693 15:52:58 SQL Execute: ORACLE - BEGIN "SP_ZY_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PZYID00 => :PZYID00,PZYH000 => :PZYH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 694 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 695 15:52:58 SQL Execute: ORACLE - select * from VW_ZY_YBJKRZ where YBJKID=? 696 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 697 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc054 698 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 699 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 700 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 701 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae072 702 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 703 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 704 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 705 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 706 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 707 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 708 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 709 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007 710 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 711 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 712 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 713 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029 714 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 715 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 716 15:52:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 135895 717 15:52:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 718 15:52:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 719 15:52:58 SQL Execute: ORACLE - select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 720 15:52:58 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3286369.000000 721 15:52:58 SQL Data In: ORACLE - Param = 2, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1049319.000000 722 15:52:58 SQL Data In: ORACLE - Param = 3, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保 723 15:52:58 SQL Data In: ORACLE - Param = 4, Name = AS_YBKH00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = H33541106 724 15:52:58 SQL Data In: ORACLE - Param = 5, Name = AS_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35212719470725211X 725 15:52:58 SQL Data In: ORACLE - Param = 6, Name = AS_YBLB00, Type = fldZSTRING, Precision = 36, Scale = 0, Data = 南平市医疗保障基金管理中心光泽管理部 726 15:52:58 SQL Data In: ORACLE - Param = 7, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 城乡居民 727 15:52:58 SQL Data In: ORACLE - Param = 8, Name = AS_BCKBCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 728 15:52:58 SQL Data In: ORACLE - Param = 9, Name = AS_ZYLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8690259 729 15:52:58 SQL Data In: ORACLE - Param = 10, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈贤柱 730 15:52:58 SQL Data In: ORACLE - Param = 11, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1111.000000 731 15:52:58 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 易联众 732 15:52:58 SQL Data In: ORACLE - Param = 13, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 733 15:52:58 SQL Data In: ORACLE - Param = 14, Name = AS_TSBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 734 15:52:58 SQL Data In: ORACLE - Param = 15, Name = AS_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 735 15:52:58 SQL Data In: ORACLE - Param = 16, Name = AS_CSLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 736 15:52:58 SQL Data In: ORACLE - Param = 17, Name = AS_DWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 737 15:52:58 SQL Data In: ORACLE - Param = 18, Name = AS_XZQH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350723 738 15:52:58 SQL Data In: ORACLE - Param = 19, Name = AS_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 739 15:52:58 SQL Data In: ORACLE - Param = 20, Name = AS_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 740 15:52:58 SQL Data In: ORACLE - Param = 21, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 741 15:52:58 SQL Data In: ORACLE - Param = 22, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 742 15:52:58 SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 743 15:52:58 SQL Data In: ORACLE - Param = 24, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 744 15:52:58 SQL Data In: ORACLE - Param = 25, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 745 15:52:58 SQL Data In: ORACLE - Param = 26, Name = AS_ICZTMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = * 746 15:52:58 SQL Data In: ORACLE - Param = 27, Name = AS_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 747 15:52:58 SQL Data In: ORACLE - Param = 28, Name = AS_GRZHYE, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 748 15:52:58 SQL Data In: ORACLE - Param = 29, Name = AS_SFRZLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 749 15:52:58 SQL Execute: ORACLE - BEGIN "SP_ZY_BRFB00_EDIT00" (AD_BRID00 => :AD_BRID00,AD_ZYID00 => :AD_ZYID00,AS_FBMC00 => :AS_FBMC00,AS_YBKH00 => :AS_YBKH00,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_BRZTQK => :AS_BRZTQK,AS_BCKBCS => :AS_BCKBCS,AS_ZYLSH0 => :AS_ZYLSH0,AS_XM0000 => :AS_XM0000,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_RYLB00 => :AS_RYLB00,AS_TSBZ00 => :AS_TSBZ00,AS_GSDJH0 => :AS_GSDJH0,AS_CSLX00 => :AS_CSLX00,AS_DWMC00 => :AS_DWMC00,AS_XZQH00 => :AS_XZQH00,AS_DBLB00 => :AS_DBLB00,AS_DBLBMC => :AS_DBLBMC,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PZXCGBZ => :PZXCGBZ,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,AS_ICZTMC => :AS_ICZTMC,AS_SFJZFP => :AS_SFJZFP,AS_GRZHYE => :AS_GRZHYE,AS_SFRZLX => :AS_SFRZLX); END; 750 15:52:58 SQL Execute: ORACLE - Commit 751 15:52:58 SQL Data In: ORACLE - Rows affected = 0 752 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 1049319.00 753 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 1049319.00 754 15:52:59 SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 1049319.00 and JZDH00+0 = 0 and CZRQ00 <= '20211025' order by MXID00 755 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 1049319.00 and KDRQ00 <= '20211025' order by SFYP00,ZXKSBH,XMBH00 756 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 1049319.00 and PLBH00 in (4,8) order by DJH000 757 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 1049319.00 order by JZDH00 758 15:52:59 SQL Execute: ORACLE - select * from VW_ZY_FBXGRZ where ZYID00 = 1049319.00 order by CZRQ00,CZSJ00 759 15:52:59 SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where BRID00 = 3286369.00 760 15:52:59 SQL Execute: ORACLE - select max(JZRQ00) from zy_jzb000 where zyid00=1049319.00 and JSLX00='3' and JZZT00='0' and HJJE00>0 761 15:52:59 SQL Execute: ORACLE - select YBBRLB,BRLBMC,BRLBJC,YBZXLB,FBBH00,MZYBZF,YBZFBL,YBQFBZ,SFMLXZ,ZYZFSX,MZZFSX,YJFDBL,YJFDSX from BM_YBBRLB where FBBH00=-1 order by FBBH00,YBZXLB,YBBRLB 762 15:52:59 SQL Execute: ORACLE - select YBLB00,YBMC00,YBZXLB,FBBH00,YBBHSB,SFXNH0,YBJGJC,CSLX00,XZQH00,JSDWBH from IC_YBBRLB where FBBH00=-1 order by FBBH00,YBZXLB,PXH000,YBLB00