1 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
2 10:14:59 SQL Execute: ORACLE - select SF_SF_ICKH00(?)FHJG00 from dual
3 10:14:59 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='福建预交金统一平台' and BH0000='Open_MZ'
4 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台
5 10:14:59 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
6 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000
7 10:14:59 SQL Execute: ORACLE - select trim(b.YYID00)YYID00 from bm_bmbm00 b where b.BMBH00=?
8 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137
9 10:14:59 SQL Execute: ORACLE - select YYQC00 from xt_yyxx00 where YYID00=?
10 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
11 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = serveraddr_222137
12 10:14:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?) as FHXX00 from dual
13 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
14 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = appid_222137
15 10:14:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?) as FHXX00 from dual
16 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
17 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = appsecret_222137
18 10:14:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?) as FHXX00 from dual
19 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
20 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = appid_ZY_222137
21 10:14:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?) as FHXX00 from dual
22 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
23 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = appsecret_ZY_222137
24 10:14:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?) as FHXX00 from dual
25 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
26 10:14:59 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=?
27 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
28 10:14:59 SQL Execute: ORACLE - Select a.*
from bm_brxxb0 a where a.brid00=?
29 10:14:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
30 10:14:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
31 10:14:59 SQL Execute: ORACLE - Select b.*
from IC_YHXX00 B where b.brid00=? and B.ZT0000=?
32 10:14:59 SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1002.000000
33 10:14:59 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
34 10:14:59 SQL Data In: ORACLE - Param = 3, Name = PCARDNO, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA25875439
35 10:14:59 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
36 10:14:59 SQL Data In: ORACLE - Param = 5, Name = PCZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 网络中心
37 10:14:59 SQL Data In: ORACLE - Param = 6, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
38 10:14:59 SQL Data In: ORACLE - Param = 7, Name = PINCS00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 医保换卡
39 10:14:59 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
40 10:14:59 SQL Data In: ORACLE - Param = 9, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
41 10:14:59 SQL Data In: ORACLE - Param = 10, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
42 10:14:59 SQL Data In: ORACLE - Param = 11, Name = PRECODE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
43 10:14:59 SQL Data In: ORACLE - Param = 12, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
44 10:14:59 SQL Execute: ORACLE - BEGIN "SP_ONEPAY_YJJPTJK" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PCARDNO => :PCARDNO,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PRECODE => :PRECODE,PERRMSG => :PERRMSG); END;
45 10:14:59 SQL Execute: ORACLE - Rollback
46 10:14:59 SQL Data In: ORACLE - Rows affected = 0
47 10:14:59 SQL Execute: ORACLE - select BRXM00,ICKH00,BRXB00,BRCSRQ,FBMC00 from VW_IC_YHXXB0 where BRID00=5189042 and ZT0000 in ('1','2') and FBBH00=3
48 10:15:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350182197205074014
49 10:15:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
50 10:15:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
51 10:15:04 SQL Execute: ORACLE - select SP_SF_CHECKSFZH(?,?,?)idcard from dual
52 10:15:04 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual
53 10:15:04 SQL Execute: ORACLE - select (select trim(MC0000) from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='Nation_AuthorizationCode') VALUE0,SF_BM_SQXQTSXX('Nation_AuthorizationCode','医保新接口参数设置',369,'495917679') TSXX00 from dual
54 10:15:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
55 10:15:04 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
56 10:15:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡
57 10:15:04 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
58 10:15:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000
59 10:15:04 SQL Execute: ORACLE - select B.GJBZBM as usr ,nvl(B.GJYBMM,b.YBYHMM) as pwd from BM_BMBM00 A,XT_YYXX00 B
where A.YYID00=B.YYID00 and A.BMBH00=?
60 10:15:04 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual
61 10:15:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
62 10:15:04 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=?
63 10:15:06 SQL Execute: ORACLE - select SQ_SF_YBJKRZ_YBJKID.Nextval from dual
64 10:15:06 SQL Execute: ORACLE - insert into SF_YBJKRZ(YBJKID,serip0,sermac,ECINFO,HISCS0)values ('5921371','192.200.31.63','E8_6A_64_8C_26_97','','N17194066201171940662350182197205074014柯永建柯永建0门诊医保换卡01')
65 10:15:06 SQL Data In: ORACLE - Rows affected = 1
66 10:15:06 SQL Data In: ORACLE - Param = 1, Name = IN_YBJKID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
67 10:15:06 SQL Data In: ORACLE - Param = 2, Name = IN_JKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
68 10:15:06 SQL Data In: ORACLE - Param = 3, Name = IN_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
69 10:15:06 SQL Data In: ORACLE - Param = 4, Name = IN_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
70 10:15:06 SQL Data In: ORACLE - Param = 5, Name = IN_GHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
71 10:15:06 SQL Data In: ORACLE - Param = 6, Name = IN_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
72 10:15:06 SQL Data In: ORACLE - Param = 7, Name = IN_CZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 网络中心
73 10:15:06 SQL Data In: ORACLE - Param = 8, Name = IN_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000
74 10:15:06 SQL Data In: ORACLE - Param = 9, Name = IN_QQCSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
75 10:15:06 SQL Data In: ORACLE - Param = 11, Name = IN_OTHER0, Type = fldZSTRING, Precision = 88, Scale = 0, Data = 320700D156000005AB28287D78627975320700
76 10:15:06 SQL Data In: ORACLE - Param = 12, Name = IN_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
77 10:15:06 SQL Data In: ORACLE - Param = 13, Name = OUT_ZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
78 10:15:06 SQL Data In: ORACLE - Param = 14, Name = OUT_YBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
79 10:15:06 SQL Data In: ORACLE - Param = 15, Name = OUT_XMLSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
80 10:15:06 SQL Data In: ORACLE - Param = 16, Name = OUT_ERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
81 10:15:06 SQL Execute: ORACLE - BEGIN "SP_SF_GJYBJK_YBJKRZ" (IN_YBJKID => :IN_YBJKID,IN_JKCJBM => :IN_JKCJBM,IN_BRID00 => :IN_BRID00,IN_GHID00 => :IN_GHID00,IN_GHH000 => :IN_GHH000,IN_CZY000 => :IN_CZY000,IN_CZYXM0 => :IN_CZYXM0,IN_CZYKS0 => :IN_CZYKS0,IN_QQCSID => :IN_QQCSID,IN_XMLSTR => :IN_XMLSTR,IN_OTHER0 => :IN_OTHER0,IN_COMMIT => :IN_COMMIT,OUT_ZXZT00 => :OUT_ZXZT00,OUT_YBJKID => :OUT_YBJKID,OUT_XMLSTR => :OUT_XMLSTR,OUT_ERRMSG => :OUT_ERRMSG); END;
82 10:15:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
83 10:15:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
84 10:15:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data
85 10:15:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
86 10:15:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
87 10:15:07 SQL Execute: ORACLE - Select SF_XT_GETCJBM_YBNODE(?,?,?,?,?) as FHXX00 from dual
88 10:15:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
89 10:15:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = AllIn
90 10:15:07 SQL Execute: ORACLE - Select a.JKSXBM,a.JKSXMC,a.JKFSZ0,a.JKFHZ0
from SF_YBJKMX a
where a.YBJKID=? and a.CJBM00=? and a.FSLXBZ in ('1','3')
order by a.JKMXID
91 10:15:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
92 10:15:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
93 10:15:07 SQL Execute: ORACLE - Select a.JKSXBM,a.JKSXMC,a.JKFSZ0,a.JKFHZ0
from SF_YBJKMX a
where a.YBJKID=? and a.CJBM00=? and a.FSLXBZ in ('1','3')
order by a.JKMXID
94 10:15:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
95 10:15:07 SQL Execute: ORACLE - select a.serurl,a.infno,a.msgid,a.mdtrtarea_admvs,a.insuplc_admdvs,
a.recer_sys_code,a.dev_no,a.cainfo,a.signtype,a.infver,
a.opter_type,a.opter,a.opter_name,a.inf_time,a.fixmedins_code,a.fixmedins_name,a.sign_no
from SF_YBJKRZ a where a.YBJKID=?
96 10:15:07 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') )
and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)
and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '44')
AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)
97 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
98 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
99 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
100 10:15:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
101 10:15:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
102 10:15:15 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
103 10:15:15 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,FLAG=?,CAUSE=?,infcode=?,err_msg=? where YBJKID=?
104 10:15:15 SQL Data In: ORACLE - Rows affected = 1
105 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
106 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = body
107 10:15:15 SQL Execute: ORACLE - Select a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0 from SF_YBJKMX a where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
108 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
109 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
110 10:15:15 SQL Execute: ORACLE - Select a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0 from SF_YBJKMX a where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
order by JKMXID
111 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
112 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
113 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = infcode
114 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
115 10:15:15 SQL Data In: ORACLE - Rows affected = 1
116 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350000202404171015174838554209
117 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
118 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = inf_refmsgid
119 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
120 10:15:15 SQL Data In: ORACLE - Rows affected = 1
121 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20240417101513007
122 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
123 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = refmsg_time
124 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
125 10:15:15 SQL Data In: ORACLE - Rows affected = 1
126 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20240417101517288
127 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
128 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = respond_time
129 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
130 10:15:15 SQL Data In: ORACLE - Rows affected = 1
131 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = hsa-fsi-local
132 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
133 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = appname
134 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
135 10:15:15 SQL Data In: ORACLE - Rows affected = 1
136 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 18b5524beb731002
137 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
138 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = mid
139 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
140 10:15:15 SQL Data In: ORACLE - Rows affected = 1
141 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
142 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
143 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = baseinfo
144 10:15:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
145 10:15:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
146 10:15:15 SQL Execute: ORACLE - Select SF_XT_GETCJBM_YBNODE(?,?,?,?,?) as FHXX00 from dual
147 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
148 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = baseinfo
149 10:15:15 SQL Execute: ORACLE - Select a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0 from SF_YBJKMX a where YBJKID=?
and JDBM00=?
and FSLXBZ in ('2','3')
and CJBM00 not in ('AllIn','AllOut')
order by JKMXID
150 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 26, Scale = 0, Data = 32070000000000001001677697
151 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
152 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = psn_no
153 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
154 10:15:15 SQL Data In: ORACLE - Rows affected = 1
155 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01
156 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
157 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = psn_cert_type
158 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
159 10:15:15 SQL Data In: ORACLE - Rows affected = 2
160 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350182197205074014
161 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
162 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = certno
163 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
164 10:15:15 SQL Data In: ORACLE - Rows affected = 2
165 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 柯永建
166 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
167 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = psn_name
168 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
169 10:15:15 SQL Data In: ORACLE - Rows affected = 2
170 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
171 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
172 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = gend
173 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
174 10:15:15 SQL Data In: ORACLE - Rows affected = 1
175 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = brdy
176 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
177 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 1972-05-07
178 10:15:15 SQL Execute: ORACLE - select sf_xt_gettamptotime(?,?,?) as fhxx00 from dual
179 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 1972-05-07
180 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
181 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = brdy
182 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
183 10:15:15 SQL Data In: ORACLE - Rows affected = 1
184 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 52
185 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
186 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = age
187 10:15:15 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and JKSXBM=?
188 10:15:15 SQL Data In: ORACLE - Rows affected = 1
189 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
190 10:15:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
191 10:15:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
192 10:15:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
193 10:15:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = insuinfo
194 10:15:15 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 参保信息列表
195 10:15:15 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 75.88
196 10:15:15 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 310
197 10:15:15 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 11
198 10:15:15 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
199 10:15:15 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
200 10:15:15 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
201 10:15:15 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
202 10:15:15 SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 320724
203 10:15:15 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 22, Scale = 0, Data = 连云港兴鑫钢铁有限公司
204 10:15:15 SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
205 10:15:15 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
206 10:15:15 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
207 10:15:15 SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
208 10:15:15 SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
209 10:15:15 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
210 10:15:15 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
211 10:15:15 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
212 10:15:15 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
213 10:15:15 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
214 10:15:15 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
215 10:15:15 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
216 10:15:15 SQL Execute: ORACLE - insert into SF_YBDATA(
YBJKID,serial,BRID00,JZDH00,JKJDBM,JKJDMC,balc,insutype,psn_type,psn_insu_stas,psn_insu_date,paus_insu_date,
cvlserv_flag,insuplc_admdvs,emp_name,psn_idet_type,psn_type_lv,memo,
begntime,endtime,fund_pay_type,inscp_scp_amt,crt_payb_lmt_amt,fund_payamt,fund_pay_type_name,setl_proc_info,xmlstr,bz
)
select
?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?
from dual
217 10:15:15 SQL Data In: ORACLE - Rows affected = 1
218 10:15:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
219 10:15:15 SQL Execute: ORACLE - select * from VW_SF_YBDATA a where a.YBJKID=? and JKJDBM='idetinfo' and memo is not null
220 10:15:16 SQL Data In: ORACLE - Param = 1, Name = IN_YBJKID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
221 10:15:16 SQL Data In: ORACLE - Param = 2, Name = IN_JKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBCX_0005
222 10:15:16 SQL Data In: ORACLE - Param = 3, Name = IN_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
223 10:15:16 SQL Data In: ORACLE - Param = 4, Name = IN_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
224 10:15:16 SQL Data In: ORACLE - Param = 5, Name = IN_GHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
225 10:15:16 SQL Data In: ORACLE - Param = 6, Name = IN_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
226 10:15:16 SQL Data In: ORACLE - Param = 7, Name = IN_CZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 网络中心
227 10:15:16 SQL Data In: ORACLE - Param = 8, Name = IN_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000
228 10:15:16 SQL Data In: ORACLE - Param = 9, Name = IN_QQCSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
229 10:15:16 SQL Data In: ORACLE - Param = 11, Name = IN_OTHER0, Type = fldZSTRING, Precision = 88, Scale = 0, Data = 320700D156000005AB28287D78627975320700
230 10:15:16 SQL Data In: ORACLE - Param = 12, Name = IN_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
231 10:15:16 SQL Data In: ORACLE - Param = 13, Name = OUT_ZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
232 10:15:16 SQL Data In: ORACLE - Param = 14, Name = OUT_XMLSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
233 10:15:16 SQL Data In: ORACLE - Param = 15, Name = OUT_ERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
234 10:15:16 SQL Execute: ORACLE - BEGIN "SP_SF_GJYBJK_YBJKQR" (IN_YBJKID => :IN_YBJKID,IN_JKCJBM => :IN_JKCJBM,IN_BRID00 => :IN_BRID00,IN_GHID00 => :IN_GHID00,IN_GHH000 => :IN_GHH000,IN_CZY000 => :IN_CZY000,IN_CZYXM0 => :IN_CZYXM0,IN_CZYKS0 => :IN_CZYKS0,IN_QQCSID => :IN_QQCSID,IN_XMLSTR => :IN_XMLSTR,IN_OTHER0 => :IN_OTHER0,IN_COMMIT => :IN_COMMIT,OUT_ZXZT00 => :OUT_ZXZT00,OUT_XMLSTR => :OUT_XMLSTR,OUT_ERRMSG => :OUT_ERRMSG); END;
235 10:15:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 医疗保障信息平台数据上传
236 10:15:16 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00
237 10:15:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = MedicalData_Upload
238 10:15:16 SQL Execute: ORACLE - Select EXEDLL from BM_TYCJBM where CJBM00=?
239 10:15:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
240 10:15:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka544
241 10:15:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
242 10:15:16 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
243 10:15:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
244 10:15:16 SQL Execute: ORACLE - select
YBJK_Ghlsh0,YBJK_djlsh0,YBJK_cardno,YBJK_icztmc,YBJK_gzztmc,YBJK_id0000,
YBJK_AAC999,YBJK_zjbh00,YBJK_FZXMC0,YBJK_xzqh00,YBJK_xming0,YBJK_xbie00,
YBJK_csrq00,YBJK_brnl00,YBJK_dwmc00,YBJK_dqmc00,YBJK_grzhye,YBJK_sfjzfp,
YBJK_sfjdlk,YBJK_bcbxf0,YBJK_jjzfe0,YBJK_zhzfe0,YBJK_grzfe0,ybjk_sybxzf,
YBJK_Dbjjzf,ybjk_bjjjzf,YBJK_gwybz0,YBJK_fybfy0,YBJK_akc227,YBJK_bkc102,
YBJK_bkc040,YBJK_bkc041,YBJK_bkc045,YBJK_bkc052,YBJK_bkc059,YBJK_bkc062,
YBJK_bkc060,YBJK_ake173,YBJK_ake026,YBJK_jkzhye,YBJK_bkc075,YBJK_bkc166,
YBJK_bkc167,YBJK_bkc011,YBJK_akc087,YBJK_aka151,YBJK_aka150,medfee_sumamt,
YBJK_bqbm00,YBJK_aaz149,YBJK_sfrq00,YBJK_sfsj00,YBJK_BKC058,YBJK_BKC053,
YBJK_BKC054,YBJK_Dbzhzf,YBJK_bkc612,ybjk_ybylzd_52,ybjk_ybylzd_53,ybjk_ybylzd_54,
ybjk_ybylzd_55,ybjk_ybylzd_56,ybjk_ybylzd_57,ybjk_ybylzd_58,ybjk_ybylzd_59,ybjk_ybylzd_60,
ybjk_ybylzd_61,ybjk_ybylzd_62,ybjk_ybylzd_63,ybjk_ybylzd_64,ybjk_ybylzd_65,ybjk_ybylzd_66,ybjk_ybylzd_67,
aac058,aac058_mc,aac004,aac004_mc,psn_no,bke284,aae140,aae140_mc,
medfee_sumamt,fund_pay_sumamt,acct_pay,psn_cash_pay,hifp_pay,psn_part_amt,hosp_part_amt,
cvlserv_pay,hifob_pay,maf_pay,oth_pay,hifes_pay,fulamt_ownpay_amt,act_pay_dedc,
overlmt_selfpay,preselfpay_amt,inscp_scp_amt,pool_prop_selfpay,hifmi_pay,hifdm_pay,balc,medins_setl_id,insuplc_admdvs
from VW_SF_NATION_YBJKRZ where YBJKID=?
245 10:15:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 灌南县
246 10:15:16 SQL Execute: ORACLE - select a.SFXNH0 from ic_ybbrlb a where YBMC00 = ?
247 10:15:16 SQL Execute: ORACLE - begin SP_SF_YBXX00_REG000(5189042,'171940662','350182197205074014','柯永建','女','','连云港兴鑫钢铁有限公司','有效','在职','灌南县',75.88,369,'350182197205074014'); end;
248 10:15:17 SQL Data In: ORACLE - Rows affected = 0
249 10:15:17 SQL Execute: ORACLE - commit
250 10:15:17 SQL Data In: ORACLE - Rows affected = 0
251 10:15:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5921371
252 10:15:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284
253 10:15:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
254 10:15:17 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual
255 10:15:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 171940662
256 10:15:17 SQL Execute: ORACLE - select SF_SF_CARDNO_ICKH00(?) FSLX00 from dual
257 10:15:17 SQL Execute: ORACLE - select Count(*) num,min(ZT0000) ZT0000 from IC_YHXX00 where ICKH00 = 'FZYB171940662'
258 10:15:17 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYB171940662
259 10:15:17 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYB171940662
260 10:15:17 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8
261 10:15:17 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data =
262 10:15:17 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-FZYB
263 10:15:17 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 9, Scale = 0, Data = 171940662
264 10:15:17 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
265 10:15:17 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
266 10:15:17 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
267 10:15:17 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
268 10:15:17 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;
269 10:15:17 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYB171940662
270 10:15:17 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
271 10:15:17 SQL Data In: ORACLE - Param = 3, Name = AS_OLDKH0, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA25875439
272 10:15:17 SQL Data In: ORACLE - Param = 4, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000
273 10:15:17 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 网络中心
274 10:15:17 SQL Data In: ORACLE - Param = 6, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 44.000000
275 10:15:17 SQL Data In: ORACLE - Param = 7, Name = AS_CARDBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
276 10:15:17 SQL Data In: ORACLE - Param = 8, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
277 10:15:17 SQL Data In: ORACLE - Param = 9, Name = AS_SFSQKF, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
278 10:15:17 SQL Data In: ORACLE - Param = 10, Name = AS_YBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
279 10:15:17 SQL Data In: ORACLE - Param = 11, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
280 10:15:17 SQL Data In: ORACLE - Param = 12, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
281 10:15:17 SQL Data In: ORACLE - Param = 13, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
282 10:15:17 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;
283 10:15:17 SQL Execute: ORACLE - commit
284 10:15:17 SQL Data In: ORACLE - Rows affected = 0
285 10:15:17 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') )
and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',44,')> 0)
and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '44')
AND (INSTR (',' || a.jsksbh || ',',',44,') > 0 or a.jsksbh is null)
286 10:15:18 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
287 10:15:18 SQL Data In: ORACLE - Param = 2, Name = PYBJKID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5921371.000000
288 10:15:18 SQL Data In: ORACLE - Param = 3, Name = PXXTBBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
289 10:15:18 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
290 10:15:18 SQL Data In: ORACLE - Param = 5, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
291 10:15:18 SQL Data In: ORACLE - Param = 6, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
292 10:15:18 SQL Execute: ORACLE - BEGIN "SP_SF_NATION_UPDATE_BRXXB0" (PBRID00 => :PBRID00,PYBJKID => :PYBJKID,PXXTBBZ => :PXXTBBZ,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END;
293 10:15:18 SQL Execute: ORACLE - commit
294 10:15:18 SQL Data In: ORACLE - Rows affected = 0
295 10:15:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
296 10:15:18 SQL Execute: ORACLE - select * from BM_BRXXB0 where BRID00=?
297 10:15:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
298 10:15:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
299 10:15:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
300 10:15:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
301 10:15:18 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data =
302 10:15:18 SQL Execute: ORACLE - select SF_XT_SHOWOTHER_BRXX00(?,?,?,?,?) as FHXX00 from dual
303 10:15:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5189042.000000
304 10:15:18 SQL Execute: ORACLE - select * from BM_BRQTXX where BRID00=?
305 10:15:18 SQL Execute: ORACLE - select * from BM_TYCJBM where CJBM00='MZSF_JD00_0003' and SFQY00='1'