select SP_SF_CHECKSFZH(:1)idcard from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 select SP_SF_CHECKSFZH('350623198001206056')idcard from dual :1=['350623198001206056'] Elapsed time: 0.003 select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' Elapsed time: 0.001 select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=:1 order by XSXH00 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00='医保新接口参数设置' order by XSXH00 :1=['医保新接口参数设置'] Elapsed time: 0.000 Select * from bm_ygbm00 where YGBH00=:1 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 Select * from bm_ygbm00 where YGBH00=0.100000000e+001 :1=[0.100000000e+001] Elapsed time: 0.001 Select * from BM_TYCJBM where CJBM00=:1 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 Select * from BM_TYCJBM where CJBM00='YBJK_YBCX_0005' :1=['YBJK_YBCX_0005'] Elapsed time: 0.001 select SQ_BM_ZFPTCS_NBID00.Nextval from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 select SQ_BM_ZFPTCS_NBID00.Nextval from dual Elapsed time: 0.001 insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20200511100146537128440','新医保接口','ND87937545李如意0门诊病人建档') Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:46 insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK20200511100146537128440','新医保接口','ND87937545李如意0门诊病人建档') Elapsed time: 0.003 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; Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) :1=['\龘 '] :2=['\龘 '] :3=['\龘 '] :4=['\龘 '] :5=['\龘 '] :6=['\龘 '] :7=['\龘 '] :8=['\龘 '] :9=['\龘 '] :10=['\龘 '] :11=['\龘 '] :12=['\龘 '] :13=['\龘 '] :14=['\龘 '] PJKCJBM=['YBJK_YBCX_0005'] PBRID00=[0.0e+2147483647] PGHID00=[0.0e+2147483647] PGHH000=[''] PCZY000=[0.100000000e+001] PCZYXM0=['易联众'] PCZYKS0=[0.610000000e+002] PQQCSID=['YBJK20200511100146537128440'] PINCS00=['ND87937545李如意0门诊病人建档'] POTHER0=['门诊病人建档'] PCOMMIT=['N'] PZXZT00=[0.100000000e+001] PYBJKID=['127414'] PERRMSG=[NULL] Elapsed time: 4.388 select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=:1 and ZJDBM0='data' Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:51 select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID='127414' and ZJDBM0='data' :1=['127414'] Elapsed time: 0.001 select count(1)as num from SF_YBJKQD where YBJKID=:1 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:51 select count(1)as num from SF_YBJKQD where YBJKID='127414' :1=['127414'] Elapsed time: 0.002 select * from SF_YBJKMX where YBJKID=:1 and JDBM00=:2 and FSLXBZ in ('1','3') order by JKMXID Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:51 select * from SF_YBJKMX where YBJKID='127414' and JDBM00='main' and FSLXBZ in ('1','3') order by JKMXID :1=['127414'] :2=['main'] Elapsed time: 0.002 select * from SF_YBJKMX where YBJKID=:1 and JDBM00=:2 and FSLXBZ in ('1','3') order by JKMXID Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:01:51 select * from SF_YBJKMX where YBJKID='127414' and JDBM00='data' and FSLXBZ in ('1','3') order by JKMXID :1=['127414'] :2=['data'] Elapsed time: 0.002 Select * from SF_YBJKMX where YBJKID=:1 and JDBM00=:2 and FSLXBZ in ('2','3') order by JKMXID Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 Select * from SF_YBJKMX where YBJKID='127414' and JDBM00='main' and FSLXBZ in ('2','3') order by JKMXID :1=['127414'] :2=['main'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='1' where YBJKID='127414' and ZDBM00='flag' :1=['1'] :2=['127414'] :3=['flag'] Elapsed time: 0.001 Select * from SF_YBJKMX where YBJKID=:1 and JDBM00=:2 and FSLXBZ in ('2','3') order by JKMXID Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 Select * from SF_YBJKMX where YBJKID='127414' and JDBM00='data' and FSLXBZ in ('2','3') order by JKMXID :1=['127414'] :2=['data'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='厦门市医疗保障基金管理中心' where YBJKID='127414' and ZDBM00='aab034_mc' :1=['厦门市医疗保障基金管理中心'] :2=['127414'] :3=['aab034_mc'] Elapsed time: 0.002 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='20180206' where YBJKID='127414' and ZDBM00='aab050' :1=['20180206'] :2=['127414'] :3=['aab050'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='D87937545' where YBJKID='127414' and ZDBM00='aaz500' :1=['D87937545'] :2=['127414'] :3=['aaz500'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='350623198001206056' where YBJKID='127414' and ZDBM00='aac002' :1=['350623198001206056'] :2=['127414'] :3=['aac002'] Elapsed time: 0.000 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='李如意' where YBJKID='127414' and ZDBM00='aac003' :1=['李如意'] :2=['127414'] :3=['aac003'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='350200' where YBJKID='127414' and ZDBM00='aab301' :1=['350200'] :2=['127414'] :3=['aab301'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='厦门市' where YBJKID='127414' and ZDBM00='aab301_mc' :1=['厦门市'] :2=['127414'] :3=['aab301_mc'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='无' where YBJKID='127414' and ZDBM00='aab004' :1=['无'] :2=['127414'] :3=['aab004'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='01' where YBJKID='127414' and ZDBM00='aac058' :1=['01'] :2=['127414'] :3=['aac058'] Elapsed time: 0.000 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='350623198001206056' where YBJKID='127414' and ZDBM00='aac999' :1=['350623198001206056'] :2=['127414'] :3=['aac999'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='男' where YBJKID='127414' and ZDBM00='aac004_mc' :1=['男'] :2=['127414'] :3=['aac004_mc'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='19800120' where YBJKID='127414' and ZDBM00='aac006' :1=['19800120'] :2=['127414'] :3=['aac006'] Elapsed time: 0.001 update SF_YBJKMX set JKFHZ0=:1 where YBJKID=:2 and ZDBM00=:3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 update SF_YBJKMX set JKFHZ0='350200' where YBJKID='127414' and ZDBM00='aab034' :1=['350200'] :2=['127414'] :3=['aab034'] Elapsed time: 0.001 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select :1,SQ_SF_YBJKMX_JKMXID.nextval,:2,:3,:4,:5,:6,:7,:8 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select '127414',SQ_SF_YBJKMX_JKMXID.nextval,'data','sflist','sflist','身份标志','2','2','是否医疗救助对象NBKA544' from dual :1=['127414'] :2=['data'] :3=['sflist'] :4=['sflist'] :5=['身份标志'] :6=['2'] :7=['2'] :8=['是否医疗救助对象NBKA544'] Elapsed time: 0.002 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select :1,SQ_SF_YBJKMX_JKMXID.nextval,:2,:3,:4,:5,:6,:7,:8 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:00 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select '127414',SQ_SF_YBJKMX_JKMXID.nextval,'data','sflist','sflist','身份标志','2','2','是否保健对象NBKA547' from dual :1=['127414'] :2=['data'] :3=['sflist'] :4=['sflist'] :5=['身份标志'] :6=['2'] :7=['2'] :8=['是否保健对象NBKA547'] Elapsed time: 0.002 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select :1,SQ_SF_YBJKMX_JKMXID.nextval,:2,:3,:4,:5,:6,:7,:8 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select '127414',SQ_SF_YBJKMX_JKMXID.nextval,'data','cbxzlist','cbxzlist','参保险种','2','2','有效城镇职工基本医疗保险外来在职厦门市医疗保障基金管理中心' from dual :1=['127414'] :2=['data'] :3=['cbxzlist'] :4=['cbxzlist'] :5=['参保险种'] :6=['2'] :7=['2'] :8=['有效城镇职工基本医疗保险外来在职厦门市医疗保障基金管理中心'] Elapsed time: 0.001 update SF_YBJKRZ set DLLZT0=:1,DLLERR=:2,FLAG=:3,CAUSE=:4,JKQQCS=:5,JKFHCS=:6 where YBJKID=:7 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 update SF_YBJKRZ set DLLZT0='0',DLLERR='',FLAG='1',CAUSE='',JKQQCS='{"usr":"350623J10535062300287","pwd":"123","funid":"yb04.10.01.17","data":{"bke284":"01","bkz543":"","ectoken":"","aaz500":"D87937545","aac002":"","aac003":"李如意","aaz501":"D87937545"}}',JKFHCS='{"flag":"1","cause":"","data":{"aac003":"李如意","aab001":"","yljzlist":[],"aac006":"19800120","aab034_mc":"厦门市医疗保障基金管理中心","dylist":[],"bke384":"","cbxzlist":[{"aae140_mc":"城镇职工基本医疗保险","aab034_mc":"厦门市医疗保障基金管理中心","bkc001_mc":"外来在职","bkc026_mc":"有效"}],"aac99 where YBJKID='127414' :1=['0'] :2=[''] :3=['1'] :4=[''] :5=['{"usr":"350623J10535062300287","pwd":"123","funid":"yb04.10.01.17","data":{"bke284":"01","bkz543":"","ectoken":"","aaz500":"D87937545","aac002":"","aac003":"李如意","aaz501":"D87937545"}}'] :6=['{"flag":"1","cause":"","data":{"aac003":"李如意","aab001":"","yljzlist":[],"aac006":"19800120","aab034_mc":"厦门市医疗保障基金管理中心","dylist":[],"bke384":"","cbxzlist":[{"aae140_mc":"城镇职工基本医疗保险","aab034_mc":"厦门市医疗保障基金管理中心","bkc001_mc":"外来在职","bkc026_mc":"有效"}],"aac99] :7=['127414'] Elapsed time: 0.003 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; Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 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; :1=['听�'] :2=['听�'] :3=['听?'] :4=['听?'] :5=['听�'] :6=['听?'] :7=['听�'] :8=['听?'] :9=['听�'] :10=['听�'] :11=['听�'] :12=['听�'] :13=['听?'] :14=['听�'] PYBJKID=['127414'] PJKCJBM=['YBJK_YBCX_0005'] PBRID00=[0.0e+2147483647] PGHID00=[0.0e+2147483647] PGHH000=[''] PCZY000=[0.100000000e+001] PCZYXM0=['易联众'] PCZYKS0=[0.610000000e+002] PQQCSID=['YBJK20200511100146537128440'] PINCS00=['ND87937545李如意0门诊病人建档'] POTHER0=['门诊病人建档'] PCOMMIT=['N'] PZXZT00=[0.100000000e+001] PERRMSG=[NULL] Elapsed time: 0.014 select * from VW_SF_YBJKRZ where YBJKID=:1 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select * from VW_SF_YBJKRZ where YBJKID='127414' :1=['127414'] Elapsed time: 0.002 select SF_SF_GETYBJKMX_NUM(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX_NUM('127414','bkc054','1') as FHXX00 from dual :1=['127414'] :2=['bkc054'] :3=['1'] Elapsed time: 0.001 select SF_SF_GETYBJKMX(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX('127414','akc190','1') as FHXX00 from dual :1=['127414'] :2=['akc190'] :3=['1'] Elapsed time: 0.001 select SF_SF_GETYBJKMX(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX('127414','aae072','1') as FHXX00 from dual :1=['127414'] :2=['aae072'] :3=['1'] Elapsed time: 0.002 select SF_SF_GETYBJKMX(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX('127414','aaz149','1') as FHXX00 from dual :1=['127414'] :2=['aaz149'] :3=['1'] Elapsed time: 0.002 select SF_SF_GETYBJKMX(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX('127414','ake007','1') as FHXX00 from dual :1=['127414'] :2=['ake007'] :3=['1'] Elapsed time: 0.001 select SF_SF_GETYBJKMX(:1,:2,:3) as FHXX00 from dual Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 select SF_SF_GETYBJKMX('127414','bae029','1') as FHXX00 from dual :1=['127414'] :2=['bae029'] :3=['1'] Elapsed time: 0.002 Select * from bm_brxxb0 where YBID00=:1 and BRXM00=:2 and FBBH00=3 Error occurred: [1036] (ORA-01036: 非法的变量名/编号 ) -------------------------------------------------------------------------------- Timestamp: 2020-05-11 10:02:01 Select * from bm_brxxb0 where YBID00='350623198001206056' and BRXM00='李如意' and FBBH00=3 :1=['350623198001206056'] :2=['李如意'] Elapsed time: 0.004