1 10:37:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
2 10:37:51 SQL Execute: ORACLE - select SF_SF_ICKH00(?)FHJG00 from dual
3 10:37:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
4 10:37:51 SQL Execute: ORACLE - select SF_SF_YYTCARDNO(?)FHJG00 from dual
5 10:37:51 SQL Execute: ORACLE - select BRXM00,ICKH00,BRXB00,BRCSRQ,FBMC00 from VW_IC_YHXXB0 where BRID00=1202480 and ZT0000 in ('1','2') and FBBH00=3
6 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
7 10:37:53 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?)idcard from dual
8 10:37:53 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
9 10:37:53 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM') VALUE0,SF_BM_SQXQTSXX('YBXJKSQM','医保新接口参数设置',830,'23745415') TSXX00 from dual
10 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
11 10:37:53 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
12 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
13 10:37:53 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
14 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
15 10:37:53 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=?
16 10:37:53 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
17 10:37:53 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK2020082010375340697685','新医保接口','NDF975739101350212198607202518张顺良0门诊医保换卡')
18 10:37:53 SQL Data In: ORACLE - Rows affected = 1
19 10:37:53 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
20 10:37:53 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
21 10:37:53 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
22 10:37:53 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
23 10:37:53 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
24 10:37:53 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 朱宝惠
25 10:37:53 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000
26 10:37:53 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 26, Scale = 0, Data = YBJK2020082010375340697685
27 10:37:53 SQL Data In: ORACLE - Param = 9, Name = PINCS00, Type = fldZSTRING, Precision = 185, Scale = 0, Data = NDF975739101350212198607202518张顺良0门诊医保换卡
28 10:37:53 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊医保换卡
29 10:37:53 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
30 10:37:53 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
31 10:37:53 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
32 10:37:53 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
33 10:37:53 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END;
34 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01
35 10:37:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
36 10:37:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284
37 10:37:53 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=?
38 10:37:53 SQL Data In: ORACLE - Rows affected = 1
39 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
40 10:37:53 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data'
41 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
42 10:37:53 SQL Execute: ORACLE - select count(1)as num from SF_YBJKQD where YBJKID=?
43 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
44 10:37:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
45 10:37:53 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
46 10:37:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
47 10:37:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
48 10:37:53 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
49 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
50 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
51 10:37:54 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
52 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
53 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
54 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag
55 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
56 10:37:54 SQL Data In: ORACLE - Rows affected = 1
57 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
58 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
59 10:37:54 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
60 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = DF9757391
61 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
62 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz500
63 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
64 10:37:54 SQL Data In: ORACLE - Rows affected = 1
65 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
66 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
67 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac002
68 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
69 10:37:54 SQL Data In: ORACLE - Rows affected = 1
70 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 张顺良
71 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
72 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac003
73 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
74 10:37:54 SQL Data In: ORACLE - Rows affected = 1
75 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350200
76 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
77 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab301
78 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
79 10:37:54 SQL Data In: ORACLE - Rows affected = 1
80 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 厦门市
81 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
82 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aab301_mc
83 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
84 10:37:54 SQL Data In: ORACLE - Rows affected = 1
85 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 无
86 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
87 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab004
88 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
89 10:37:54 SQL Data In: ORACLE - Rows affected = 1
90 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01
91 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
92 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac058
93 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
94 10:37:54 SQL Data In: ORACLE - Rows affected = 1
95 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 居民身份证（户口簿）
96 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
97 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aac058_mc
98 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
99 10:37:54 SQL Data In: ORACLE - Rows affected = 1
100 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
101 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
102 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac999
103 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
104 10:37:54 SQL Data In: ORACLE - Rows affected = 1
105 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
106 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
107 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac004
108 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
109 10:37:54 SQL Data In: ORACLE - Rows affected = 1
110 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
111 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
112 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = aac004_mc
113 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
114 10:37:54 SQL Data In: ORACLE - Rows affected = 1
115 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19860720
116 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
117 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac006
118 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
119 10:37:54 SQL Data In: ORACLE - Rows affected = 1
120 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5326.81
121 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
122 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc087
123 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
124 10:37:54 SQL Data In: ORACLE - Rows affected = 1
125 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 4251.4
126 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
127 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc079
128 10:37:54 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
129 10:37:54 SQL Data In: ORACLE - Rows affected = 1
130 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
131 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
132 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist
133 10:37:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist
134 10:37:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 身份标志
135 10:37:54 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
136 10:37:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
137 10:37:54 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 120, Scale = 0, Data = 是否医疗救助对象NBKA544
138 10:37:54 SQL Execute: ORACLE - insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0)
select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,?
from dual
139 10:37:54 SQL Data In: ORACLE - Rows affected = 1
140 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
141 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
142 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist
143 10:37:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sflist
144 10:37:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 身份标志
145 10:37:54 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
146 10:37:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
147 10:37:54 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 116, Scale = 0, Data = 是否保健对象NBKA547
148 10:37:54 SQL Execute: ORACLE - insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0)
select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,?
from dual
149 10:37:54 SQL Data In: ORACLE - Rows affected = 1
150 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
151 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
152 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = cbxzlist
153 10:37:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = cbxzlist
154 10:37:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 参保险种
155 10:37:54 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
156 10:37:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
157 10:37:54 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = 有效城镇职工基本医疗保险在职人员31020170730350200101厦门市医疗保障基金管理中心
158 10:37:54 SQL Execute: ORACLE - insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0)
select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,?
from dual
159 10:37:54 SQL Data In: ORACLE - Rows affected = 1
160 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
161 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
162 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
163 10:37:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
164 10:37:54 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 199, Scale = 0, Data = {"usr":"350200021135021205646","pwd":"888888","funid":"yb04.10.01.16","data":{"bke284":"01","bkz543":"","ectoken":"","aaz500":"DF9757391","aac002":"350212198607202518","aac003":"张顺良","aaz501":""}}
165 10:37:54 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
166 10:37:54 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=?
167 10:37:54 SQL Data In: ORACLE - Rows affected = 1
168 10:37:54 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
169 10:37:54 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
170 10:37:54 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
171 10:37:54 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
172 10:37:54 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
173 10:37:54 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
174 10:37:54 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 朱宝惠
175 10:37:54 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000
176 10:37:54 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 26, Scale = 0, Data = YBJK2020082010375340697685
177 10:37:54 SQL Data In: ORACLE - Param = 10, Name = PINCS00, Type = fldZSTRING, Precision = 185, Scale = 0, Data = NDF975739101350212198607202518张顺良0门诊医保换卡
178 10:37:54 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 门诊医保换卡
179 10:37:54 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
180 10:37:54 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
181 10:37:54 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
182 10:37:54 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
183 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
184 10:37:54 SQL Execute: ORACLE - select * from SF_YBJKRZ where YBJKID=?
185 10:37:54 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL
186 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
187 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc190
188 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
189 10:37:54 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
190 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
191 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae072
192 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
193 10:37:54 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
194 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
195 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149
196 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
197 10:37:54 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
198 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
199 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007
200 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
201 10:37:54 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
202 10:37:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 26839
203 10:37:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029
204 10:37:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
205 10:37:54 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
206 10:37:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 厦门市医疗保障基金管理中心
207 10:37:56 SQL Execute: ORACLE - select a.SFXNH0 from ic_ybbrlb a where YBMC00 = ?
208 10:37:56 SQL Execute: ORACLE - begin SP_SF_YBXX00_REG000(1202480,'DF9757391','350212198607202518','张顺良','男','','无','有效','在职人员','厦门市医疗保障基金管理中心',5326.81,830,'350212198607202518'); end;
209 10:37:56 SQL Data In: ORACLE - Rows affected = 0
210 10:37:56 SQL Execute: ORACLE - commit
211 10:37:56 SQL Data In: ORACLE - Rows affected = 0
212 10:37:56 SQL Execute: ORACLE - Select SYSDATE from Dual
213 10:37:56 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH'
214 10:37:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')
and KLLB00='1'
215 10:37:56 SQL Execute: ORACLE - select Count(*) num,min(ZT0000) ZT0000 from IC_YHXX00 where ICKH00 = 'XMYBDF9757391'
216 10:37:56 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
217 10:37:56 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
218 10:37:56 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8
219 10:37:56 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
220 10:37:56 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = YB-SBK
221 10:37:56 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 9, Scale = 0, Data = DF9757391
222 10:37:56 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
223 10:37:56 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
224 10:37:56 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
225 10:37:56 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
226 10:37:56 SQL Execute: ORACLE - BEGIN "SP_SF_ICKRK0_REG000" (P_ICKNBH => :P_ICKNBH,P_ICKH00 => :P_ICKH00,P_YWCZ00 => :P_YWCZ00,P_ICKMM0 => :P_ICKMM0,P_KLDH00 => :P_KLDH00,P_KMH000 => :P_KMH000,P_SFDM00 => :P_SFDM00,P_YGBH00 => :P_YGBH00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
227 10:37:56 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
228 10:37:56 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
229 10:37:56 SQL Data In: ORACLE - Param = 3, Name = AS_OLDKH0, Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDC9375595
230 10:37:56 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
231 10:37:56 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 朱宝惠
232 10:37:56 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000
233 10:37:56 SQL Data In: ORACLE - Param = 7, Name = AS_CARDBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
234 10:37:56 SQL Data In: ORACLE - Param = 8, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
235 10:37:56 SQL Data In: ORACLE - Param = 9, Name = AS_SFSQKF, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
236 10:37:56 SQL Data In: ORACLE - Param = 10, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
237 10:37:56 SQL Data In: ORACLE - Param = 11, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
238 10:37:56 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
239 10:37:56 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
240 10:37:56 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;
241 10:37:57 SQL Execute: ORACLE - commit
242 10:37:57 SQL Data In: ORACLE - Rows affected = 0
243 10:37:58 SQL Execute: ORACLE - select icguid from ic_yhxx00 where brid00='1202480' and icguid is not null and rownum=1
244 10:37:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
245 10:37:58 SQL Execute: ORACLE - select SF_SF_ICKH00(?)FHJG00 from dual
246 10:37:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
247 10:37:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDC9375595
248 10:37:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = XMYB
249 10:37:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
250 10:37:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 就诊卡换卡
251 10:37:58 SQL Execute: ORACLE - select SF_SF_XMJKKH(?,?,?,?,?) FSDYLX from dual
252 10:37:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
253 10:37:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
254 10:37:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = XMYB
255 10:37:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
256 10:37:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 就诊卡换卡
257 10:37:58 SQL Execute: ORACLE - select SF_SF_XMJKKH(?,?,?,?,?) FSDYLX from dual
258 10:37:59 SQL Execute: ORACLE - update IC_YHXX00 SET SCBZ00='1' where ICKH00='XMYBDF9757391'
259 10:37:59 SQL Data In: ORACLE - Rows affected = 1
260 10:37:59 SQL Execute: ORACLE - COMMIT
261 10:37:59 SQL Data In: ORACLE - Rows affected = 0
262 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = DC9375595
263 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2002
264 10:37:59 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual
265 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
266 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5000
267 10:37:59 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual
268 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
269 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = IpAdd
270 10:37:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
271 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
272 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Port
273 10:37:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
274 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
275 10:37:59 SQL Execute: ORACLE - select SF_SF_KMH000(?)FHJG00 from dual
276 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
277 10:37:59 SQL Execute: ORACLE - select SF_SF_ICGUID(?)FHJG00 from dual
278 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
279 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
280 10:37:59 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
281 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
282 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
283 10:37:59 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
284 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
285 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = YCZXCS
286 10:37:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
287 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
288 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen
289 10:37:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
290 10:37:59 SQL Execute: ORACLE - select nvl(max(trim(ICGUID)),'-1') ICGUID from VW_IC_SMBTDJ where ICKH00='XMYBDF9757391'
291 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
292 10:37:59 SQL Execute: ORACLE - select SF_SF_GETBRID(?)FHJG00 from dual
293 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
294 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
295 10:37:59 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
296 10:37:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
297 10:37:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2001
298 10:37:59 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual
299 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
300 10:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = IpAdd
301 10:38:00 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
302 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
303 10:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Port
304 10:38:00 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
305 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
306 10:38:00 SQL Execute: ORACLE - select SF_SF_KMH000(?)FHJG00 from dual
307 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
308 10:38:00 SQL Execute: ORACLE - select SF_SF_ICGUID(?)FHJG00 from dual
309 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
310 10:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
311 10:38:00 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
312 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
313 10:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
314 10:38:00 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
315 10:38:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
316 10:38:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = YCZXCS
317 10:38:00 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
318 10:38:00 SQL Execute: ORACLE - select BRXM00,BRXB00,BRCSRQ,BRZTQK,TYDWMC,YBKH00,YBID00,BRZJBH,BRZJLX from BM_BRXXB0 where BRID00=1202480
319 10:38:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 厦门市社保中心
320 10:38:26 SQL Execute: ORACLE - select * from ic_ybbrlb where YBMC00 = ?
321 10:38:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
322 10:38:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
323 10:38:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
324 10:38:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15160728428
325 10:38:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15160728428
326 10:38:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
327 10:38:26 SQL Execute: ORACLE - select SF_SF_BRSFZJY(?,?,?,?,?,?) BRZJBH from dual
328 10:38:26 SQL Execute: ORACLE - select count(*) from ZY_BRXXB0 where BRID00=1202480 and CYRQ00 is null
329 10:38:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 17
330 10:38:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 58
331 10:38:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
332 10:38:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
333 10:38:26 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 17,58,-1,24
334 10:38:26 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
335 10:38:26 SQL Execute: ORACLE - select SF_SF_BRDZBM(?,?,?,?,?,?) FSDYLX from dual
336 10:38:26 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
337 10:38:26 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
338 10:38:26 SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = *352770
339 10:38:26 SQL Data In: ORACLE - Param = 4, Name = AS_BRGFZH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
340 10:38:26 SQL Data In: ORACLE - Param = 5, Name = AS_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 张顺良
341 10:38:26 SQL Data In: ORACLE - Param = 6, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女
342 10:38:26 SQL Data In: ORACLE - Param = 7, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
343 10:38:26 SQL Data In: ORACLE - Param = 8, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19860720
344 10:38:26 SQL Data In: ORACLE - Param = 9, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
345 10:38:26 SQL Data In: ORACLE - Param = 10, Name = AS_BRZY00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 农民
346 10:38:26 SQL Data In: ORACLE - Param = 11, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族
347 10:38:26 SQL Data In: ORACLE - Param = 12, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国
348 10:38:26 SQL Data In: ORACLE - Param = 13, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证
349 10:38:26 SQL Data In: ORACLE - Param = 14, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
350 10:38:26 SQL Data In: ORACLE - Param = 15, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保
351 10:38:26 SQL Data In: ORACLE - Param = 16, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 厦门市
352 10:38:26 SQL Data In: ORACLE - Param = 17, Name = AS_BRDH00, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15160728428
353 10:38:26 SQL Data In: ORACLE - Param = 18, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 福建省厦门市同安区祥平街道
354 10:38:26 SQL Data In: ORACLE - Param = 19, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
355 10:38:26 SQL Data In: ORACLE - Param = 20, Name = AS_BRYB01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
356 10:38:26 SQL Data In: ORACLE - Param = 21, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
357 10:38:26 SQL Data In: ORACLE - Param = 22, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 无
358 10:38:26 SQL Data In: ORACLE - Param = 23, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
359 10:38:26 SQL Data In: ORACLE - Param = 24, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
360 10:38:26 SQL Data In: ORACLE - Param = 25, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
361 10:38:26 SQL Data In: ORACLE - Param = 26, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 11, Scale = 0, Data = 15160728428
362 10:38:26 SQL Data In: ORACLE - Param = 27, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 在职人员
363 10:38:26 SQL Data In: ORACLE - Param = 28, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
364 10:38:26 SQL Data In: ORACLE - Param = 29, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000
365 10:38:26 SQL Data In: ORACLE - Param = 30, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
366 10:38:26 SQL Data In: ORACLE - Param = 31, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 复诊
367 10:38:26 SQL Data In: ORACLE - Param = 32, Name = AS_YBICKH, Type = fldZSTRING, Precision = 9, Scale = 0, Data = DF9757391
368 10:38:26 SQL Data In: ORACLE - Param = 33, Name = AS_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350212198607202518
369 10:38:26 SQL Data In: ORACLE - Param = 34, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
370 10:38:26 SQL Data In: ORACLE - Param = 35, Name = AS_SFMZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
371 10:38:26 SQL Data In: ORACLE - Param = 36, Name = AD_SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
372 10:38:26 SQL Data In: ORACLE - Param = 37, Name = AS_SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
373 10:38:26 SQL Data In: ORACLE - Param = 38, Name = AS_BRSZSF, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省
374 10:38:26 SQL Data In: ORACLE - Param = 39, Name = AS_BRSZS0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 厦门市同安区
375 10:38:26 SQL Data In: ORACLE - Param = 40, Name = AS_BRSZZ0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 祥平街道
376 10:38:26 SQL Data In: ORACLE - Param = 41, Name = AS_BRSZC0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 红唐2里
377 10:38:26 SQL Data In: ORACLE - Param = 42, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
378 10:38:26 SQL Data In: ORACLE - Param = 43, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
379 10:38:26 SQL Data In: ORACLE - Param = 44, Name = AS_TSSXMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通
380 10:38:26 SQL Data In: ORACLE - Param = 45, Name = as_SFSY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
381 10:38:26 SQL Data In: ORACLE - Param = 46, Name = as_JG0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
382 10:38:26 SQL Data In: ORACLE - Param = 47, Name = as_SFBJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
383 10:38:26 SQL Data In: ORACLE - Param = 48, Name = as_SFBYZG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
384 10:38:26 SQL Data In: ORACLE - Param = 49, Name = as_HZDWMC, Type = fldZSTRING, Precision = 5, Scale = 0, Data = sssss
385 10:38:26 SQL Data In: ORACLE - Param = 50, Name = as_BRDZBM, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
386 10:38:26 SQL Data In: ORACLE - Param = 51, Name = as_SFGHXZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
387 10:38:26 SQL Data In: ORACLE - Param = 52, Name = as_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
388 10:38:26 SQL Data In: ORACLE - Param = 53, Name = as_ZYFL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
389 10:38:26 SQL Data In: ORACLE - Param = 54, Name = as_ZYZFL0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
390 10:38:26 SQL Execute: ORACLE - BEGIN "SP_SF_BRXXB0_EDIT00" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,AS_BRGFZH => :AS_BRGFZH,AS_BRXM00 => :AS_BRXM00,AS_BRXB00 => :AS_BRXB00,AS_BRXX00 => :AS_BRXX00,AS_BRCSRQ => :AS_BRCSRQ,AS_BRHYZK => :AS_BRHYZK,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRGJ00 => :AS_BRGJ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_FBMC00 => :AS_FBMC00,AS_BRDYFW => :AS_BRDYFW,AS_BRDH00 => :AS_BRDH00,AS_BRJTDZ => :AS_BRJTDZ,AS_BRYB00 => :AS_BRYB00,AS_BRYB01 => :AS_BRYB01,AD_TYDWID => :AD_TYDWID,AS_TYDWMC => :AS_TYDWMC,AS_BRLXGX => :AS_BRLXGX,AS_BRLXXM => :AS_BRLXXM,AS_BRLXDZ => :AS_BRLXDZ,AS_BRLXDH => :AS_BRLXDH,AS_BRZTQK => :AS_BRZTQK,AS_BRJKQK => :AS_BRJKQK,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_BRLX00 => :AS_BRLX00,AS_YBICKH => :AS_YBICKH,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFMZ00 => :AS_SFMZ00,AD_SFYD00 => :AD_SFYD00,AS_SFYXJB => :AS_SFYXJB,AS_BRSZSF => :AS_BRSZSF,AS_BRSZS0 => :AS_BRSZS0,AS_BRSZZ0 => :AS_BRSZZ0,AS_BRSZC0 => :AS_BRSZC0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_TSSXMC => :AS_TSSXMC,as_SFSY00 => :as_SFSY00,as_JG0000 => :as_JG0000,as_SFBJ00 => :as_SFBJ00,as_SFBYZG => :as_SFBYZG,as_HZDWMC => :as_HZDWMC,as_BRDZBM => :as_BRDZBM,as_SFGHXZ => :as_SFGHXZ,as_SFJZFP => :as_SFJZFP,as_ZYFL00 => :as_ZYFL00,as_ZYZFL0 => :as_ZYZFL0); END;
391 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
392 10:38:27 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00= ? and ZT0000='1'
393 10:38:27 SQL Execute: ORACLE - select ICKH00,BRID00 from VW_IC_SMBTDJ where ICKH00='XMYBDF9757391'
394 10:38:27 SQL Execute: ORACLE - select * from VW_IC_SMBTDJ where BRID00=1202480
395 10:38:27 SQL Execute: ORACLE - update IC_YHXX00 set SCBZ00='4' where ICKH00='XMYBDF9757391'
396 10:38:27 SQL Data In: ORACLE - Rows affected = 1
397 10:38:27 SQL Execute: ORACLE - Commit
398 10:38:27 SQL Data In: ORACLE - Rows affected = 0
399 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
400 10:38:27 SQL Execute: ORACLE - select SF_SF_ICKH00(?)FHJG00 from dual
401 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = XMYBDF9757391
402 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 5001
403 10:38:27 SQL Execute: ORACLE - select SF_SF_YYTOPEN(?,?)FHJG00 from dual
404 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
405 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = IpAdd
406 10:38:27 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
407 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
408 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Port
409 10:38:27 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
410 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
411 10:38:27 SQL Execute: ORACLE - select SF_SF_KMH000(?)FHJG00 from dual
412 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
413 10:38:27 SQL Execute: ORACLE - select SF_SF_ICGUID(?)FHJG00 from dual
414 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
415 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
416 10:38:27 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
417 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
418 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
419 10:38:27 SQL Execute: ORACLE - select SF_SF_ZHDJZT(?,?)FHJG00 from dual
420 10:38:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台
421 10:38:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = YCZXCS
422 10:38:27 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
423 10:39:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
424 10:39:25 SQL Execute: ORACLE - select * from BM_BRZPXX where brid00 = ?
425 10:39:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1202480.000000
426 10:39:25 SQL Execute: ORACLE - select SF_SF_ICKH00(?)FHJG00 from dual
427 10:39:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数
428 10:39:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT
429 10:39:25 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual
430 10:39:25 SQL Execute: ORACLE - Commit
431 10:39:25 SQL Data In: ORACLE - Rows affected = 0
432 10:39:25 SQL Execute: ORACLE - select TXNR00 from BM_HMDML0 where SFZH00='350212198607202518'