1 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
2 17:47:55 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1
and PJSYR0=?
and SYBZ00 = 'Y'
3 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
4 17:47:55 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=?
5 17:47:55 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(328526,7167240,0) YYKSBM from dual
6 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
7 17:47:55 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=?
8 17:47:55 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(328526,7167240,1) YYKSBM from dual
9 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
10 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7167240
11 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
12 17:47:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
13 17:47:55 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211102
14 17:47:55 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211102
15 17:47:55 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual
16 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
17 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 中医内科
18 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 本院挂号
19 17:47:55 SQL Execute: ORACLE - select SF_SF_FSDYLX(?,?,?) FSDYLX from dual
20 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
21 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2
22 17:47:55 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1
and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in
(select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0
and b.brid00= ?)
and d.srrq00>=to_char(sysdate-?,'YYYYMMDD')
23 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
24 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
25 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7
26 17:47:55 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1
and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0
and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000
and a.JZDH00+0 = 0
and a.brid00= ?)
and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD')
27 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
28 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2
29 17:47:55 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1
and a.ghh000=f.ghh000 and B.BRID00= ?
and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0
and A.srrq00>=to_char(sysdate-?,'YYYYMMDD')
and A.YPDLBH=D.LBBH00
30 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
31 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
32 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7
33 17:47:55 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1
and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0
and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000
and a.JZDH00> 0
and a.brid00= ?)
and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD')
34 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
35 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
36 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2
37 17:47:55 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1
and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=?
and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?)
and B.srrq00>=to_char(sysdate-?,'YYYYMMDD')
and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00
38 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
39 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
40 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
41 17:47:55 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1
and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ?
and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?)
and B.srrq00>=to_char(sysdate-?,'YYYYMMDD')
and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00
42 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
43 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
44 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7
45 17:47:55 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1
and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0
and D.brid00= ?
and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?)
and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD')
and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00
46 17:47:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
47 17:47:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7167240
48 17:47:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
49 17:47:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
50 17:47:55 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
51 17:47:55 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
52 17:47:55 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual
53 17:47:57 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
54 17:47:57 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
55 17:47:57 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7167240
56 17:47:57 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
57 17:47:57 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
58 17:47:57 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
59 17:47:57 SQL Data In: ORACLE - Param = 7, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
60 17:47:57 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,PID0000 => :PID0000); END;
61 17:47:57 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
62 17:47:57 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
63 17:47:57 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
64 17:47:57 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7167240
65 17:47:57 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
66 17:47:57 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
67 17:47:57 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
68 17:47:57 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
69 17:47:57 SQL Data In: ORACLE - Param = 9, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
70 17:47:57 SQL Data In: ORACLE - Param = 10, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
71 17:47:57 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CFLSH0 => :AS_CFLSH0,PID0000 => :PID0000); END;
72 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
73 17:47:57 SQL Execute: ORACLE - select NVL(sum(XMJE00),0) HJJE00 from SF_FYXX00_TEMPMX WHERE ID0000=?
74 17:47:57 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
75 17:47:57 SQL Data In: ORACLE - Param = 2, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4697012.000000
76 17:47:57 SQL Data In: ORACLE - Param = 3, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
77 17:47:57 SQL Data In: ORACLE - Param = 4, Name = PXMCXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
78 17:47:57 SQL Data In: ORACLE - Param = 5, Name = PNEWJS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
79 17:47:57 SQL Execute: ORACLE - BEGIN "SP_SF_YBXEFP" (PBRID00 => :PBRID00,PID0000 => :PID0000,PCOMMIT => :PCOMMIT,PXMCXID => :PXMCXID,PNEWJS0 => :PNEWJS0); END;
80 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3452061.000000
81 17:47:57 SQL Execute: ORACLE - select NVL(sum(FPCEJE),0) FPCEJE, NVL(sum(FPXE00),0)FPXE00 from VW_SF_YBXEFP WHERE ID0000=? AND CEZT00=1
82 17:47:57 SQL Execute: ORACLE - COMMIT
83 17:47:57 SQL Data In: ORACLE - Rows affected = 0
84 17:47:57 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
85 17:47:57 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM') VALUE0,SF_BM_SQXQTSXX('YBXJKSQM','医保新接口参数设置',398,'124952826') TSXX00 from dual
86 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
87 17:47:57 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
88 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
89 17:47:57 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
90 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
91 17:47:57 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B
where A.YYID00=B.YYID00 and A.BMBH00=?
92 17:47:57 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual
93 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = YBJK_MXSC_0026_2
94 17:47:57 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=?
95 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
96 17:47:57 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM
from bm_brxxb0 a where a.brid00=?
97 17:47:57 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
98 17:47:57 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20211102174758355708255','新医保接口','Y01328526125567957167240123401434697012N0门诊费用登记_新')
99 17:47:57 SQL Data In: ORACLE - Rows affected = 1
100 17:47:57 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 16, Scale = 0, Data = YBJK_MXSC_0026_2
101 17:47:57 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
102 17:47:57 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12556795.000000
103 17:47:57 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7167240
104 17:47:57 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
105 17:47:57 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄阳山
106 17:47:57 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
107 17:47:57 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211102174758355708255
108 17:47:57 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 15, Scale = 0, Data = 门诊费用登记_新
109 17:47:57 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
110 17:47:57 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
111 17:47:57 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
112 17:47:57 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
113 17:47:57 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;
114 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01
115 17:47:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
116 17:47:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284
117 17:47:57 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=?
118 17:47:57 SQL Data In: ORACLE - Rows affected = 1
119 17:47:57 SQL Execute: ORACLE - COMMIT
120 17:47:57 SQL Data In: ORACLE - Rows affected = 0
121 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
122 17:47:57 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data'
123 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
124 17:47:57 SQL Execute: ORACLE - select count(1)as num from SF_YBJKQD where YBJKID=?
125 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
126 17:47:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
127 17:47:57 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
128 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
129 17:47:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
130 17:47:57 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
131 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
132 17:47:57 SQL Execute: ORACLE - select distinct(JDBM00) as listbm from SF_YBJKMX where YBJKID=? and ZJDBM0='data'
133 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
134 17:47:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zdlist
135 17:47:57 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
136 17:47:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
137 17:47:57 SQL Execute: ORACLE - select * from SF_YBJKQD where YBJKID=? order by JKMXID
138 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
139 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
140 17:47:58 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
141 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
142 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
143 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag
144 17:47:58 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
145 17:47:58 SQL Data In: ORACLE - Rows affected = 1
146 17:47:58 SQL Execute: ORACLE - COMMIT
147 17:47:58 SQL Data In: ORACLE - Rows affected = 0
148 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功
149 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
150 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause
151 17:47:58 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
152 17:47:58 SQL Data In: ORACLE - Rows affected = 1
153 17:47:58 SQL Execute: ORACLE - COMMIT
154 17:47:58 SQL Data In: ORACLE - Rows affected = 0
155 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
156 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
157 17:47:58 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
158 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 16358465488724494044
159 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
160 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke297
161 17:47:58 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
162 17:47:58 SQL Data In: ORACLE - Rows affected = 1
163 17:47:58 SQL Execute: ORACLE - COMMIT
164 17:47:58 SQL Data In: ORACLE - Rows affected = 0
165 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
166 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功
167 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
168 17:47:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功
169 17:47:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 85, Scale = 0, Data = {"traceid":"","flag":"1","data":{"bke297":"16358465488724494044"},"cause":"操作成功"}
170 17:47:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
171 17:47:58 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=?
172 17:47:58 SQL Data In: ORACLE - Rows affected = 1
173 17:47:58 SQL Execute: ORACLE - COMMIT
174 17:47:58 SQL Data In: ORACLE - Rows affected = 0
175 17:47:58 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
176 17:47:58 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 16, Scale = 0, Data = YBJK_MXSC_0026_2
177 17:47:58 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
178 17:47:58 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12556795.000000
179 17:47:58 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7167240
180 17:47:58 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
181 17:47:58 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄阳山
182 17:47:58 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
183 17:47:58 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211102174758355708255
184 17:47:58 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 15, Scale = 0, Data = 门诊费用登记_新
185 17:47:58 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
186 17:47:58 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
187 17:47:58 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
188 17:47:58 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;
189 17:47:58 SQL Execute: ORACLE - COMMIT
190 17:47:58 SQL Data In: ORACLE - Rows affected = 0
191 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985834
192 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke297
193 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
194 17:47:58 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
195 17:47:58 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
196 17:47:58 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM') VALUE0,SF_BM_SQXQTSXX('YBXJKSQM','医保新接口参数设置',398,'124952826') TSXX00 from dual
197 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
198 17:47:58 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
199 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
200 17:47:58 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
201 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
202 17:47:58 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B
where A.YYID00=B.YYID00 and A.BMBH00=?
203 17:47:58 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual
204 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = YBJK_TYSF_0020_2
205 17:47:58 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=?
206 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
207 17:47:58 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM
from bm_brxxb0 a where a.brid00=?
208 17:47:58 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual
209 17:47:58 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20211102174759509708256','新医保接口','Y0132852612556795716724012340143163584654887244940444697012N0门诊费用登记_新')
210 17:47:58 SQL Data In: ORACLE - Rows affected = 1
211 17:47:58 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 16, Scale = 0, Data = YBJK_TYSF_0020_2
212 17:47:58 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 328526.000000
213 17:47:58 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12556795.000000
214 17:47:58 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 7167240
215 17:47:58 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 398.000000
216 17:47:58 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 黄阳山
217 17:47:58 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000
218 17:47:58 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 27, Scale = 0, Data = YBJK20211102174759509708256
219 17:47:58 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 15, Scale = 0, Data = 门诊费用登记_新
220 17:47:58 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
221 17:47:58 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
222 17:47:58 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
223 17:47:58 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
224 17:47:58 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;
225 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01
226 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
227 17:47:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284
228 17:47:58 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=?
229 17:47:58 SQL Data In: ORACLE - Rows affected = 1
230 17:47:58 SQL Execute: ORACLE - COMMIT
231 17:47:58 SQL Data In: ORACLE - Rows affected = 0
232 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
233 17:47:58 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data'
234 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
235 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
236 17:47:58 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
237 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
238 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
239 17:47:58 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
240 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
241 17:47:58 SQL Execute: ORACLE - select distinct(JDBM00) as listbm from SF_YBJKMX where YBJKID=? and ZJDBM0='data'
242 17:47:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
243 17:47:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cflist
244 17:47:58 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=?
and FSLXBZ in ('1','3') order by JKMXID
245 17:48:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
246 17:48:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
247 17:48:00 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
248 17:48:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 120011
249 17:48:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
250 17:48:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag
251 17:48:00 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
252 17:48:00 SQL Data In: ORACLE - Rows affected = 1
253 17:48:00 SQL Execute: ORACLE - COMMIT
254 17:48:00 SQL Data In: ORACLE - Rows affected = 0
255 17:48:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 250, Scale = 0, Data = 请求接口异常：(1432e01cbe69f002)FSI-FMI返回：系统错误：[60320212]MBS系统错误，请联系技术支持人员!异常信息为：匹配明细分割规则提示:费用明细分割：阳光采购目录:XA05BAL080H002010200190传入单位：瓶与计价单位：盒/丸不一致 -> 匹配明细分割规则提示:费用明细分
256 17:48:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
257 17:48:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause
258 17:48:00 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=?
259 17:48:00 SQL Data In: ORACLE - Rows affected = 1
260 17:48:00 SQL Execute: ORACLE - COMMIT
261 17:48:00 SQL Data In: ORACLE - Rows affected = 0
262 17:48:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -2
263 17:48:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 200, Scale = 0, Data = 请求接口异常：(1432e01cbe69f002)FSI-FMI返回：系统错误：[60320212]MBS系统错误，请联系技术支持人员!异常信息为：匹配明细分割规则提示:费用明细分割：阳光采购目录:XA05BAL080H002010200190传入单位：瓶与计价单
264 17:48:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 120011
265 17:48:00 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 985835
266 17:48:00 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=?
267 17:48:00 SQL Data In: ORACLE - Rows affected = 1
268 17:48:00 SQL Execute: ORACLE - COMMIT
269 17:48:00 SQL Data In: ORACLE - Rows affected = 0
270 17:48:00 SQL Execute: ORACLE - COMMIT
271 17:48:00 SQL Data In: ORACLE - Rows affected = 0