1 15:18:22 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL
2 15:18:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数
3 15:18:22 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
4 15:18:22 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
5 15:18:22 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='多点结算接口参数' and BH0000='DDJSJK_SQM') VALUE0,SF_BM_SQXQTSXX('DDJSJK_SQM','多点结算接口参数',71025,'51783122') TSXX00 from dual
6 15:18:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
7 15:18:22 SQL Execute: ORACLE - select
b.ZYH000,b.BRID00,b.ZYID00,b.FBBH00,b.YBZYH0,b.RYRQ00,b.RYSJ00,b.RYLB00,
b.RYBQ00,b.DQBQ00,b.RYCWH0,b.CYRQ00,b.CYSJ00,b.DBZBM0,b.YBLB00,b.YBBRLB,
a.BRBLH0,a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRCSRQ,a.BRZJLX,a.BRZJBH,
a.BRDH00,a.BRLXXM,a.BRLXDZ,a.BRLXDH
from bm_brxxb0 a,zy_brxxb0 b
where a.brid00=b.brid00 and b.zyid00=?
8 15:18:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
9 15:18:22 SQL Execute: ORACLE - Select a.*,b.bmmc00 from bm_ygbm00 a,bm_bmbm00 b where a.bmbh00=b.bmbh00 and a.YGBH00=?
10 15:18:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
11 15:18:22 SQL Execute: ORACLE - Select b.* from bm_bmbm00 b where b.bmbh00=?
12 15:18:22 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
13 15:18:22 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('20021DD9605381','多点结算HIS请求参数','20021DDD多点结算转费别171025测试护士85716518018385112600961921Y')
14 15:18:22 SQL Data In: ORACLE - Rows affected = 1
15 15:18:22 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20021.000000
16 15:18:22 SQL Data In: ORACLE - Param = 2, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD
17 15:18:22 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
18 15:18:22 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
19 15:18:22 SQL Data In: ORACLE - Param = 5, Name = PCARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00961921
20 15:18:22 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
21 15:18:22 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
22 15:18:22 SQL Data In: ORACLE - Param = 8, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试护士
23 15:18:22 SQL Data In: ORACLE - Param = 9, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
24 15:18:22 SQL Data In: ORACLE - Param = 10, Name = PKSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
25 15:18:22 SQL Data In: ORACLE - Param = 11, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
26 15:18:22 SQL Data In: ORACLE - Param = 12, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
27 15:18:22 SQL Data In: ORACLE - Param = 13, Name = PYBGHH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
28 15:18:22 SQL Data In: ORACLE - Param = 14, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
29 15:18:22 SQL Data In: ORACLE - Param = 15, Name = PCSNBID, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20021DD9605381
30 15:18:22 SQL Data In: ORACLE - Param = 16, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
31 15:18:22 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
32 15:18:22 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
33 15:18:22 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
34 15:18:22 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
35 15:18:22 SQL Execute: ORACLE - BEGIN "SP_ZY_DDJSJKRZ" (PJKLXBH => :PJKLXBH,PJKLX00 => :PJKLX00,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PCARDNO => :PCARDNO,PMZZYBZ => :PMZZYBZ,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PJZDH00 => :PJZDH00,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PCSNBID => :PCSNBID,PBYRC00 => :PBYRC00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END;
36 15:18:22 SQL Execute: ORACLE - COMMIT
37 15:18:22 SQL Data In: ORACLE - Rows affected = 0
38 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H50505940
39 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = H50505940
40 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
41 15:19:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cardno
42 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFSZ0=?,XML000=? where DDLSH0=? and JKFSBM=?
43 15:19:02 SQL Data In: ORACLE - Rows affected = 1
44 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
45 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 35, Scale = 0, Data = 350702198305221312
46 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
47 15:19:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = id0000
48 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFSZ0=?,XML000=? where DDLSH0=? and JKFSBM=?
49 15:19:02 SQL Data In: ORACLE - Rows affected = 1
50 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
51 15:19:02 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and JDBM00 in ('Readcard_Info')
and FSLX00 in ('2','3')
order by MXID00
52 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H50505940
53 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
54 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = pCardno
55 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
56 15:19:02 SQL Data In: ORACLE - Rows affected = 1
57 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
58 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
59 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = pId
60 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
61 15:19:02 SQL Data In: ORACLE - Rows affected = 1
62 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 黄巍
63 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
64 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = pName
65 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
66 15:19:02 SQL Data In: ORACLE - Rows affected = 1
67 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
68 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
69 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = pSex
70 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
71 15:19:02 SQL Data In: ORACLE - Rows affected = 1
72 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
73 15:19:02 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and nvl(JDBM00,'Body') not in ('Readcard_Info')
and FSLX00 in ('2','3')
order by MXID00
74 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 310
75 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
76 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cblx00
77 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
78 15:19:02 SQL Data In: ORACLE - Rows affected = 1
79 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H50505940
80 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
81 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cardno
82 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
83 15:19:02 SQL Data In: ORACLE - Rows affected = 1
84 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
85 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
86 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = id0000
87 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
88 15:19:02 SQL Data In: ORACLE - Rows affected = 1
89 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 黄巍
90 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
91 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = xming0
92 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
93 15:19:02 SQL Data In: ORACLE - Rows affected = 1
94 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 39
95 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
96 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = brnl00
97 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
98 15:19:02 SQL Data In: ORACLE - Rows affected = 1
99 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 南平市医疗保障基金管理中心
100 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
101 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = fzxmc0
102 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
103 15:19:02 SQL Data In: ORACLE - Rows affected = 1
104 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 在职人员
105 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
106 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = gzztmc
107 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
108 15:19:02 SQL Data In: ORACLE - Rows affected = 1
109 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16480.43
110 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
111 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = grzhye
112 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
113 15:19:02 SQL Data In: ORACLE - Rows affected = 1
114 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
115 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
116 15:19:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sfzhao
117 15:19:02 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
118 15:19:02 SQL Data In: ORACLE - Rows affected = 1
119 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
120 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = hisExtra
121 15:19:02 SQL Execute: ORACLE - Select * from ZY_YBFSJD where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00
122 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
123 15:19:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra
124 15:19:02 SQL Execute: ORACLE - Select * from ZY_YBFSJD where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00
125 15:19:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
126 15:19:02 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and FSLX00 in ('1','3') order by MXID00
127 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
128 15:19:03 SQL Execute: ORACLE - update ZY_YBJK00 set JKFHCS=? where DDLSH0=?
129 15:19:03 SQL Data In: ORACLE - Rows affected = 1
130 15:19:03 SQL Execute: ORACLE - COMMIT
131 15:19:03 SQL Data In: ORACLE - Rows affected = 0
132 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0000
133 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 处理成功
134 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
135 15:19:03 SQL Execute: ORACLE - update ZY_YBJK00 set JKFHBM=?,JKFHXX=? where DDLSH0=?
136 15:19:03 SQL Data In: ORACLE - Rows affected = 1
137 15:19:03 SQL Execute: ORACLE - COMMIT
138 15:19:03 SQL Data In: ORACLE - Rows affected = 0
139 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
140 15:19:03 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and nvl(JDBM00,'Body') not in ('Readcard_Info')
and FSLX00 in ('2','3')
order by MXID00
141 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0000
142 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
143 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = retCode
144 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
145 15:19:03 SQL Data In: ORACLE - Rows affected = 1
146 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 处理成功
147 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
148 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = retMsg
149 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
150 15:19:03 SQL Data In: ORACLE - Rows affected = 1
151 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = H50505940
152 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
153 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cardno
154 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
155 15:19:03 SQL Data In: ORACLE - Rows affected = 1
156 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
157 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
158 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = id0000
159 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
160 15:19:03 SQL Data In: ORACLE - Rows affected = 1
161 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 黄巍
162 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
163 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = xming0
164 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
165 15:19:03 SQL Data In: ORACLE - Rows affected = 1
166 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
167 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
168 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = xbie00
169 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
170 15:19:03 SQL Data In: ORACLE - Rows affected = 1
171 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
172 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
173 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = xbiemc
174 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
175 15:19:03 SQL Data In: ORACLE - Rows affected = 1
176 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 南平市医疗保障基金管理中心
177 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
178 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = fzxmc0
179 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
180 15:19:03 SQL Data In: ORACLE - Rows affected = 1
181 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 在职人员
182 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
183 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = gzztmc
184 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
185 15:19:03 SQL Data In: ORACLE - Rows affected = 1
186 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 南平市
187 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
188 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = xqmc00
189 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
190 15:19:03 SQL Data In: ORACLE - Rows affected = 1
191 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 福建省南平市第一医院
192 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
193 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = dwmc00
194 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
195 15:19:03 SQL Data In: ORACLE - Rows affected = 1
196 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16480.43
197 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
198 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = grzhye
199 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
200 15:19:03 SQL Data In: ORACLE - Rows affected = 1
201 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
202 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
203 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = sfzhao
204 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
205 15:19:03 SQL Data In: ORACLE - Rows affected = 1
206 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19830522
207 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
208 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = csrq00
209 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
210 15:19:03 SQL Data In: ORACLE - Rows affected = 1
211 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 城镇职工基本医疗保险
212 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
213 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = yblbmc
214 15:19:03 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
215 15:19:03 SQL Data In: ORACLE - Rows affected = 1
216 15:19:03 SQL Execute: ORACLE - select SQ_BM_JKFHZ0_ID0000.nextval from dual
217 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 133915
218 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 20021
219 15:19:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 易慧多点结算
220 15:19:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
221 15:19:03 SQL Execute: ORACLE - insert into BM_JKFHZ0(ID0000, CJBM00, CJMC00, DDLSH0,HCXX00
)
values(
?,?, ?, ?, ?
)
222 15:19:03 SQL Data In: ORACLE - Rows affected = 1
223 15:19:03 SQL Execute: ORACLE - COMMIT
224 15:19:03 SQL Data In: ORACLE - Rows affected = 0
225 15:19:03 SQL Execute: ORACLE - COMMIT
226 15:19:03 SQL Data In: ORACLE - Rows affected = 0
227 15:19:03 SQL Data In: ORACLE - Param = 1, Name = PDDLSH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
228 15:19:03 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20021.000000
229 15:19:03 SQL Data In: ORACLE - Param = 3, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD
230 15:19:03 SQL Data In: ORACLE - Param = 4, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
231 15:19:03 SQL Data In: ORACLE - Param = 5, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
232 15:19:03 SQL Data In: ORACLE - Param = 6, Name = PCARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00961921
233 15:19:03 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
234 15:19:03 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
235 15:19:03 SQL Data In: ORACLE - Param = 9, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试护士
236 15:19:03 SQL Data In: ORACLE - Param = 10, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
237 15:19:03 SQL Data In: ORACLE - Param = 11, Name = PKSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
238 15:19:03 SQL Data In: ORACLE - Param = 12, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
239 15:19:03 SQL Data In: ORACLE - Param = 13, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
240 15:19:03 SQL Data In: ORACLE - Param = 14, Name = PYBGHH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
241 15:19:03 SQL Data In: ORACLE - Param = 15, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
242 15:19:03 SQL Data In: ORACLE - Param = 16, Name = PCSNBID, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20021DD9605381
243 15:19:03 SQL Data In: ORACLE - Param = 17, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
244 15:19:03 SQL Data In: ORACLE - Param = 18, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
245 15:19:03 SQL Data In: ORACLE - Param = 19, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
246 15:19:03 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
247 15:19:03 SQL Execute: ORACLE - BEGIN "SP_ZY_DDJSJKQR" (PDDLSH0 => :PDDLSH0,PJKLXBH => :PJKLXBH,PJKLX00 => :PJKLX00,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PCARDNO => :PCARDNO,PMZZYBZ => :PMZZYBZ,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PJZDH00 => :PJZDH00,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PCSNBID => :PCSNBID,PBYRC00 => :PBYRC00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
248 15:19:03 SQL Execute: ORACLE - COMMIT
249 15:19:03 SQL Data In: ORACLE - Rows affected = 0
250 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071518220097
251 15:19:03 SQL Execute: ORACLE - select * from ZY_YBFSZX where ddlsh0 =?
252 15:19:03 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL
253 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 多点结算接口参数
254 15:19:03 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
255 15:19:03 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
256 15:19:03 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='多点结算接口参数' and BH0000='DDJSJK_SQM') VALUE0,SF_BM_SQXQTSXX('DDJSJK_SQM','多点结算接口参数',71025,'51783122') TSXX00 from dual
257 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
258 15:19:03 SQL Execute: ORACLE - select
b.ZYH000,b.BRID00,b.ZYID00,b.FBBH00,b.YBZYH0,b.RYRQ00,b.RYSJ00,b.RYLB00,
b.RYBQ00,b.DQBQ00,b.RYCWH0,b.CYRQ00,b.CYSJ00,b.DBZBM0,b.YBLB00,b.YBBRLB,
a.BRBLH0,a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRCSRQ,a.BRZJLX,a.BRZJBH,
a.BRDH00,a.BRLXXM,a.BRLXDZ,a.BRLXDH
from bm_brxxb0 a,zy_brxxb0 b
where a.brid00=b.brid00 and b.zyid00=?
259 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
260 15:19:03 SQL Execute: ORACLE - Select a.*,b.bmmc00 from bm_ygbm00 a,bm_bmbm00 b where a.bmbh00=b.bmbh00 and a.YGBH00=?
261 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
262 15:19:03 SQL Execute: ORACLE - Select b.* from bm_bmbm00 b where b.bmbh00=?
263 15:19:03 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
264 15:19:03 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('20022DD9605389','多点结算HIS请求参数','20022DDD多点结算转费别171025测试护士85716518018385112600961921YH50505940350702198305221312')
265 15:19:03 SQL Data In: ORACLE - Rows affected = 1
266 15:19:03 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20022.000000
267 15:19:03 SQL Data In: ORACLE - Param = 2, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD
268 15:19:03 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
269 15:19:03 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
270 15:19:03 SQL Data In: ORACLE - Param = 5, Name = PCARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00961921
271 15:19:03 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
272 15:19:03 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
273 15:19:03 SQL Data In: ORACLE - Param = 8, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试护士
274 15:19:03 SQL Data In: ORACLE - Param = 9, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
275 15:19:03 SQL Data In: ORACLE - Param = 10, Name = PKSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
276 15:19:03 SQL Data In: ORACLE - Param = 11, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
277 15:19:03 SQL Data In: ORACLE - Param = 12, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
278 15:19:03 SQL Data In: ORACLE - Param = 13, Name = PYBGHH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
279 15:19:03 SQL Data In: ORACLE - Param = 14, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
280 15:19:03 SQL Data In: ORACLE - Param = 15, Name = PCSNBID, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20022DD9605389
281 15:19:03 SQL Data In: ORACLE - Param = 16, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
282 15:19:03 SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
283 15:19:03 SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
284 15:19:03 SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
285 15:19:03 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
286 15:19:03 SQL Execute: ORACLE - BEGIN "SP_ZY_DDJSJKRZ" (PJKLXBH => :PJKLXBH,PJKLX00 => :PJKLX00,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PCARDNO => :PCARDNO,PMZZYBZ => :PMZZYBZ,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PJZDH00 => :PJZDH00,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PCSNBID => :PCSNBID,PBYRC00 => :PBYRC00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END;
287 15:19:03 SQL Execute: ORACLE - COMMIT
288 15:19:03 SQL Data In: ORACLE - Rows affected = 0
289 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
290 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = hisExtra
291 15:19:03 SQL Execute: ORACLE - Select * from ZY_YBFSJD where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00
292 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
293 15:19:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra
294 15:19:03 SQL Execute: ORACLE - Select * from ZY_YBFSJD where DDLSH0=? and JDBM00=? and FSLX00 in ('1','3') order by MXID00
295 15:19:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
296 15:19:03 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and FSLX00 in ('1','3') order by MXID00
297 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
298 15:19:05 SQL Execute: ORACLE - update ZY_YBJK00 set JKFHCS=? where DDLSH0=?
299 15:19:05 SQL Data In: ORACLE - Rows affected = 1
300 15:19:05 SQL Execute: ORACLE - COMMIT
301 15:19:05 SQL Data In: ORACLE - Rows affected = 0
302 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0000
303 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 处理成功
304 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
305 15:19:05 SQL Execute: ORACLE - update ZY_YBJK00 set JKFHBM=?,JKFHXX=? where DDLSH0=?
306 15:19:05 SQL Data In: ORACLE - Rows affected = 1
307 15:19:05 SQL Execute: ORACLE - COMMIT
308 15:19:05 SQL Data In: ORACLE - Rows affected = 0
309 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
310 15:19:05 SQL Execute: ORACLE - Select * from ZY_YBFSZX where DDLSH0=? and nvl(JDBM00,'Body') not in ('Readcard_Info')
and FSLX00 in ('2','3')
order by MXID00
311 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0000
312 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
313 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = retCode
314 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
315 15:19:05 SQL Data In: ORACLE - Rows affected = 1
316 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 处理成功
317 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
318 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = retMsg
319 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
320 15:19:05 SQL Data In: ORACLE - Rows affected = 1
321 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220607
322 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
323 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zyrq00
324 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
325 15:19:05 SQL Data In: ORACLE - Rows affected = 1
326 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1517
327 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
328 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zysj00
329 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
330 15:19:05 SQL Data In: ORACLE - Rows affected = 1
331 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试科室
332 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
333 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zyksmc
334 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
335 15:19:05 SQL Data In: ORACLE - Rows affected = 1
336 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 141150483
337 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
338 15:19:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zylsh0
339 15:19:05 SQL Execute: ORACLE - update ZY_YBFSZX set JKFHZ0=? where DDLSH0=? and JKFSBM=?
340 15:19:05 SQL Data In: ORACLE - Rows affected = 1
341 15:19:05 SQL Execute: ORACLE - COMMIT
342 15:19:05 SQL Data In: ORACLE - Rows affected = 0
343 15:19:05 SQL Data In: ORACLE - Param = 1, Name = PDDLSH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
344 15:19:05 SQL Data In: ORACLE - Param = 2, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20022.000000
345 15:19:05 SQL Data In: ORACLE - Param = 3, Name = PJKLX00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = DD
346 15:19:05 SQL Data In: ORACLE - Param = 4, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
347 15:19:05 SQL Data In: ORACLE - Param = 5, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
348 15:19:05 SQL Data In: ORACLE - Param = 6, Name = PCARDNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00961921
349 15:19:05 SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
350 15:19:05 SQL Data In: ORACLE - Param = 8, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
351 15:19:05 SQL Data In: ORACLE - Param = 9, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试护士
352 15:19:05 SQL Data In: ORACLE - Param = 10, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
353 15:19:05 SQL Data In: ORACLE - Param = 11, Name = PKSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
354 15:19:05 SQL Data In: ORACLE - Param = 12, Name = PJSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
355 15:19:05 SQL Data In: ORACLE - Param = 13, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
356 15:19:05 SQL Data In: ORACLE - Param = 14, Name = PYBGHH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
357 15:19:05 SQL Data In: ORACLE - Param = 15, Name = PYBDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
358 15:19:05 SQL Data In: ORACLE - Param = 16, Name = PCSNBID, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 20022DD9605389
359 15:19:05 SQL Data In: ORACLE - Param = 17, Name = PBYRC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
360 15:19:05 SQL Data In: ORACLE - Param = 18, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
361 15:19:05 SQL Data In: ORACLE - Param = 19, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
362 15:19:05 SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
363 15:19:05 SQL Execute: ORACLE - BEGIN "SP_ZY_DDJSJKQR" (PDDLSH0 => :PDDLSH0,PJKLXBH => :PJKLXBH,PJKLX00 => :PJKLX00,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PCARDNO => :PCARDNO,PMZZYBZ => :PMZZYBZ,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PJZDH00 => :PJZDH00,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PCSNBID => :PCSNBID,PBYRC00 => :PBYRC00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
364 15:19:05 SQL Execute: ORACLE - COMMIT
365 15:19:05 SQL Data In: ORACLE - Rows affected = 0
366 15:19:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = DD202206071519030098
367 15:19:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zylsh0
368 15:19:05 SQL Execute: ORACLE - select * from ZY_YBFSZX where DDLSH0=? and JKFSBM=?
369 15:19:05 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
370 15:19:05 SQL Data In: ORACLE - Param = 2, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
371 15:19:05 SQL Data In: ORACLE - Param = 3, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保
372 15:19:05 SQL Data In: ORACLE - Param = 4, Name = AS_YBKH00, Type = fldZSTRING, Precision = 9, Scale = 0, Data = H50505940
373 15:19:05 SQL Data In: ORACLE - Param = 5, Name = AS_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198305221312
374 15:19:05 SQL Data In: ORACLE - Param = 6, Name = AS_YBLB00, Type = fldZSTRING, Precision = 26, Scale = 0, Data = 南平市医疗保障基金管理中心
375 15:19:05 SQL Data In: ORACLE - Param = 7, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 在职人员
376 15:19:05 SQL Data In: ORACLE - Param = 8, Name = AS_BCKBCS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
377 15:19:05 SQL Data In: ORACLE - Param = 9, Name = AS_ZYLSH0, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 141150483
378 15:19:05 SQL Data In: ORACLE - Param = 10, Name = AS_XM0000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 黄巍
379 15:19:05 SQL Data In: ORACLE - Param = 11, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71025.000000
380 15:19:05 SQL Data In: ORACLE - Param = 12, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 测试护士
381 15:19:05 SQL Data In: ORACLE - Param = 13, Name = AS_RYLB00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通
382 15:19:05 SQL Data In: ORACLE - Param = 14, Name = AS_TSBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
383 15:19:05 SQL Data In: ORACLE - Param = 15, Name = as_GSDJH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
384 15:19:05 SQL Data In: ORACLE - Param = 16, Name = as_DWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
385 15:19:05 SQL Data In: ORACLE - Param = 17, Name = as_BRGFZH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
386 15:19:05 SQL Data In: ORACLE - Param = 18, Name = as_XZQH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
387 15:19:05 SQL Data In: ORACLE - Param = 19, Name = as_DBLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
388 15:19:05 SQL Data In: ORACLE - Param = 20, Name = as_DBLBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
389 15:19:05 SQL Data In: ORACLE - Param = 21, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
390 15:19:05 SQL Data In: ORACLE - Param = 22, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
391 15:19:05 SQL Data In: ORACLE - Param = 23, Name = as_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
392 15:19:05 SQL Data In: ORACLE - Param = 24, Name = as_BRDYFW, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
393 15:19:05 SQL Data In: ORACLE - Param = 25, Name = AS_SFJZFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
394 15:19:05 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_DWMC00 => :as_DWMC00,as_BRGFZH => :as_BRGFZH,as_XZQH00 => :as_XZQH00,as_DBLB00 => :as_DBLB00,as_DBLBMC => :as_DBLBMC,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_COMMIT => :as_COMMIT,as_BRDYFW => :as_BRDYFW,AS_SFJZFP => :AS_SFJZFP); END;
395 15:19:08 SQL Execute: ORACLE - Commit
396 15:19:08 SQL Data In: ORACLE - Rows affected = 0
397 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 857
398 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 已收治
399 15:19:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 00961921
400 15:19:10 SQL Execute: ORACLE - select a.*
from VW_ZY_BRXXB0 a
where 1=1
and DQBQ00=?
and BRXXZT=?
and ZYH000=?
401 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
402 15:19:10 SQL Execute: ORACLE - select A.XMBH00,substrb(A.XMMC00,1,200)XMMC00,substrb(A.XMGG00,1,50)XMGG00,substrb(A.XMDW00,1,50)XMDW00,
A.XMDJ00,A.XMSL00,A.HJJE00,A.CZRQ00,A.CZSJ00
from VW_ZY_RQDMX_HZ A where 1=1
and A.JZDH00=0
and A.ZYID00 = ?
order by A.CZRQ00 desc
403 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
404 15:19:10 SQL Execute: ORACLE - select A.FPXMBH as FPXMID, A.FPXMMC,sum(A.HJJE00)FPXMJE from VW_ZY_RQDMX_HZ A where 1=1
and A.JZDH00=0
and A.ZYID00 = ?
group by A.FPXMBH, A.FPXMMC
order by A.FPXMBH
405 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
406 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
407 15:19:10 SQL Execute: ORACLE - select A.*,DECODE(A.JFBZ00,'0','交费','1','退费','2','作废','未知') JFBZMC,
C.JFLBMC, E.PJXH00,D.ZWXM00,
substrb(SF_SF_ZFMXMC(A.ZFFS00,A.ZFFSMC,A.ZFMXBH),1,20)ZFMXMC
FROM ZY_BRJFB0 A,BM_BRJFLB C,BM_YGBM00 D,zy_pjsyqk E
where A.JFLBID = C.JFLBID
and A.JFCZY0 = D.YGBH00
and A.JFJE00 <> 0
and A.PJH000 = E.PJH000(+)
and A.BRID00 =?
and A.ZYID00 =?
order by A.DJH000
408 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
409 15:19:10 SQL Execute: ORACLE - select * from ZY_BRZHXX A
where A.JFLBID =2
and A.BRID00 =?
410 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
411 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
412 15:19:10 SQL Execute: ORACLE - select A.*,B.ZYH000
FROM ZY_JZB000 A,ZY_BRXXB0 B
where 1=1 and a.zyid00=b.zyid00 and a.brid00=b.brid00
and A.BRID00 =?
and A.ZYID00 =?
and a.HJJE00>=0
and A.JZDH00 not in (select cxjzdh from ZY_JZB000 b where b.zyid00=a.zyid00 and b.brid00=a.brid00)
order by A.JZDH00 desc
413 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
414 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
415 15:19:10 SQL Execute: ORACLE - select Sum(A.JFJE00)JFJE00 from ZY_BRJFB0 A,BM_ZFRZ00 B
where A.DJH000=B.DJH000 and a.BRID00=B.BRID00
and A.BRID00=? and A.JZDH00=?
and A.ZFFS00 in (24,25,28) and A.JFBZ00='1'
and B.JKLXBH=43 and nvl(B.TQTK00,'0') in ('2','4')
416 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
417 15:19:10 SQL Execute: ORACLE - select A.XMBH00,substrb(A.XMMC00,1,200)XMMC00,substrb(A.XMGG00,1,50)XMGG00,substrb(A.XMDW00,1,50)XMDW00,
A.XMDJ00,A.XMSL00,A.HJJE00,A.CZRQ00,A.CZSJ00
from VW_ZY_RQDMX_HZ A where 1=1
and A.JZDH00=0
and A.ZYID00 = ?
order by A.CZRQ00 desc
418 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
419 15:19:10 SQL Execute: ORACLE - select A.FPXMBH as FPXMID, A.FPXMMC,sum(A.HJJE00)FPXMJE from VW_ZY_RQDMX_HZ A where 1=1
and A.JZDH00=0
and A.ZYID00 = ?
group by A.FPXMBH, A.FPXMMC
order by A.FPXMBH
420 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
421 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
422 15:19:10 SQL Execute: ORACLE - select A.*,DECODE(A.JFBZ00,'0','交费','1','退费','2','作废','未知') JFBZMC,
C.JFLBMC, E.PJXH00,D.ZWXM00,
substrb(SF_SF_ZFMXMC(A.ZFFS00,A.ZFFSMC,A.ZFMXBH),1,20)ZFMXMC
FROM ZY_BRJFB0 A,BM_BRJFLB C,BM_YGBM00 D,zy_pjsyqk E
where A.JFLBID = C.JFLBID
and A.JFCZY0 = D.YGBH00
and A.JFJE00 <> 0
and A.PJH000 = E.PJH000(+)
and A.BRID00 =?
and A.ZYID00 =?
order by A.DJH000
423 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
424 15:19:10 SQL Execute: ORACLE - select * from ZY_BRZHXX A
where A.JFLBID =2
and A.BRID00 =?
425 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16518018.000000
426 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3851126.000000
427 15:19:10 SQL Execute: ORACLE - select A.*,B.ZYH000
FROM ZY_JZB000 A,ZY_BRXXB0 B
where 1=1 and a.zyid00=b.zyid00 and a.brid00=b.brid00
and A.BRID00 =?
and A.ZYID00 =?
and a.HJJE00>=0
and A.JZDH00 not in (select cxjzdh from ZY_JZB000 b where b.zyid00=a.zyid00 and b.brid00=a.brid00)
order by A.JZDH00 desc
428 15:19:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
429 15:19:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
430 15:19:10 SQL Execute: ORACLE - select Sum(A.JFJE00)JFJE00 from ZY_BRJFB0 A,BM_ZFRZ00 B
where A.DJH000=B.DJH000 and a.BRID00=B.BRID00
and A.BRID00=? and A.JZDH00=?
and A.ZFFS00 in (24,25,28) and A.JFBZ00='1'
and B.JKLXBH=43 and nvl(B.TQTK00,'0') in ('2','4')
431 15:19:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 857.000000
432 15:19:21 SQL Execute: ORACLE - select * from xt_dzgg00 where FSKS00=? and xtdm00='9' and
yxzzrq>=to_char(sysdate,'yyyymmdd') and yxzzrq||yxzzsj>=to_char(sysdate,'yyyymmddhh24:mi:ss')