1 09:44:05 Log started for: 门诊挂号收费管理系统 2 09:44:05 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 09:44:05 SQL Execute: ORACLE - Insert into SD_HOSPITAL.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.187','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','144','41017' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9999:B408B0585E841B408DD25C7B06F2EE52' from dual 4 09:44:05 SQL Data In: ORACLE - Rows affected = 1 5 09:44:05 SQL Execute: ORACLE - Commit 6 09:44:05 SQL Data In: ORACLE - Rows affected = 0 7 09:44:05 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 09:44:05 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='223455' 9 09:44:05 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 10 09:44:05 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 09:44:05 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.187','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','136','39883' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'SD_HOSPITAL@9999:50D8254BFCD65165B84AE9C2C8D1EE7B' from dual 12 09:44:05 SQL Data In: ORACLE - Rows affected = 1 13 09:44:05 SQL Execute: ORACLE - Commit 14 09:44:05 SQL Data In: ORACLE - Rows affected = 0 15 09:44:05 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 16 09:44:05 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 17 09:44:05 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='XT_SFKQCADLYZ' 18 09:44:05 SQL Execute: ORACLE - select nvl(SFSDYH,'0') from BM_YGBM00 where XKH000='9999' 19 09:44:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 20 09:44:12 SQL Execute: ORACLE - Insert into SD_HOSPITAL.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.187','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','136','39887' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9999:32948CA42A15B172CB7BF80BC2C8637C' from dual 21 09:44:12 SQL Data In: ORACLE - Rows affected = 1 22 09:44:12 SQL Execute: ORACLE - Commit 23 09:44:12 SQL Data In: ORACLE - Rows affected = 0 24 09:44:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 25 09:44:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='223455' 26 09:44:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 27 09:44:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 28 09:44:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.8.187','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','144','41031' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'SD_HOSPITAL@9999:ED00587FE55714BFF4F7659553512E4D' from dual 29 09:44:12 SQL Data In: ORACLE - Rows affected = 1 30 09:44:12 SQL Execute: ORACLE - Commit 31 09:44:12 SQL Data In: ORACLE - Rows affected = 0 32 09:44:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 33 09:44:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 34 09:44:12 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='XT_SFKQCADLYZ' 35 09:44:12 SQL Execute: ORACLE - select nvl(SFSDYH,'0') from BM_YGBM00 where XKH000='9999' 36 09:44:12 SQL Execute: ORACLE - Select SYSDATE from Dual 37 09:44:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 38 09:44:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 39 09:44:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 40 09:44:12 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 41 09:44:12 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 42 09:44:12 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by b.PLXH00,a.BH0000 43 09:44:12 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999') 44 09:44:12 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1 45 09:44:12 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 09:44:12 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 47 09:44:12 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 48 09:44:12 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 09:44:12 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select Rpad(to_char(SID),30),Rpad(to_char(SERIAL#),30) from V$session where AUDSID= userenv('SESSIONID')) 50 09:44:12 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1812328,1,'HJYYZX-PD8187','4',nvl('666260',' '),'134.138.151.187-192.168.8.187#144:41031@PrjMZ_MZSF.exe+门诊挂号收费管理系统',51) 51 09:44:12 SQL Data In: ORACLE - Rows affected = 1 52 09:44:12 SQL Execute: ORACLE - Commit 53 09:44:12 SQL Data In: ORACLE - Rows affected = 0 54 09:44:12 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 51 55 09:44:12 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '223455' 56 09:44:12 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 57 09:44:12 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.8.187' 58 09:44:12 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 59 09:44:12 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 51 and FLAG00 like '%' order by decode(CKBH00,39,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 60 09:44:12 SQL Execute: ORACLE - select FSBYJ0 from BM_CKBM00 where BMBH00= 51 and FLAG00 like '%' and CKBH00='35' 61 09:44:12 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('223455') 62 09:44:12 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (nvl(a.YYID00,'0')='223455' or trim(nvl(a.YYID00,'0'))='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'4'||',')>0 ) 63 09:44:15 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1' and name00='SYSTEMSKIN' 64 09:44:15 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 65 09:44:15 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20190706' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',51,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='4') 66 09:44:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') and (SYXT00='999' or instr(','||SYXT00||',',',4,')>0 ) 67 09:44:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 68 09:44:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 69 09:44:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 70 09:44:15 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 71 09:44:15 SQL Execute: ORACLE - select BH0000,MC0000,WBSM00 from BM_TYZD00 where ZDMC00='系统登录版本设置' and BH0000 in('4') and YXBZ00='1' 72 09:44:15 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 1= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1 and XTDM00='4'))) 73 09:44:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 74 09:44:16 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1 and XTDM00='0 '))) 75 09:44:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 76 09:44:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1 and XTDM00='+ '))) 77 09:44:16 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 78 09:44:17 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 79 09:44:17 SQL Data In: ORACLE - Rows affected = 0 80 09:44:17 SQL Execute: ORACLE - Commit 81 09:44:17 SQL Data In: ORACLE - Rows affected = 0 82 09:44:17 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 83 09:44:17 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 84 09:44:17 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 85 09:44:17 SQL Execute: ORACLE - select sysdate nowtime from dual 86 09:44:17 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 1 87 09:44:17 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE','SF_PJGDZS') 88 09:44:17 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','SF_SFDYMZBL','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_SFGBTLYBTS','SF_YBSFFSGHKSBM') 89 09:44:17 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 90 09:44:17 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000001 91 09:44:17 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 92 09:44:17 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX','SF_JKRBBSFXSGHF','SF_SFMRDYFW','SF_SFQYPOSJK','SF_FYJSFPDYLX','SST_ZZJSFY','SF_YBBRCYJSSFBCWJ','SF_YBBRFYDJKYJE_PT','ZY_SFDQSBKSFZ') 93 09:44:17 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL99' order by YBYLZD 94 09:44:17 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM50' order by YBYLZD 95 09:44:17 SQL Execute: ORACLE - select userenv('SESSIONID') JCID00 from dual 96 09:44:17 SQL Execute: ORACLE - select VALUE0,SF_BM_SQXQTSXX('SF_XNHFK','0',1,'666260') TSXX00 from XT_XTCS00 where name00='SF_XNHFK' 97 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 非税收入医疗票据开票接口 98 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Open 99 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 100 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 非税收入医疗票据开票接口 101 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Version 102 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 103 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 104 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 105 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 106 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 银医通共享平台 107 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = payopen 108 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 109 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 民生通系统参数 110 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = PmstOpen 111 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 112 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 113 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 114 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 115 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 116 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 117 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 118 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 119 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JSHSFHC 120 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 121 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 122 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JKQYSQM 123 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 124 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 125 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = SFJYSZFW 126 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 127 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 128 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = ZFTKXZ_MZ 129 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 130 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 131 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 132 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 133 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 134 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = YBXJKSQM 135 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 136 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 发送外部接口数据 137 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Open 138 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 139 09:44:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 140 09:44:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 141 09:44:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 142 09:44:21 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='4' and (MKDM00='4TSBZ' or MKDM00='4BLBF') and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) 143 09:44:21 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 7 and PJSYR0 =1 and SYBZ00 = 'Y' 144 09:44:21 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 145 09:44:21 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 146 09:44:21 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 147 09:44:21 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 148 09:44:21 SQL Execute: ORACLE - select * from VW_SF_BRJFLB where JFLBID <> 0 149 09:44:21 SQL Execute: ORACLE - select * from BM_BRZTB0 150 09:44:21 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 151 09:44:21 SQL Execute: ORACLE - select * from VW_BM_BRZFFS where 1=1 and ZFFSBH<>18 order by nvl(XSXH00,0),ZFFSBH 152 09:44:23 SQL Execute: ORACLE - Select SYSDATE from Dual 153 09:44:23 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 154 09:44:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 155 09:44:23 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 156 09:44:24 SQL Execute: ORACLE - select * from IC_YHXX00 where ICKH00='PTYBPT30100661505' and ZT0000<>'0' 157 09:44:27 SQL Execute: ORACLE - select COUNT(*) ls_COUNT0 from BM_BRXXB0 where BRBLH0 ='' 158 09:44:27 SQL Execute: ORACLE - select SQ_BM_BRXXB0_BRBLH0.nextval BLH000 from dual 159 09:44:33 SQL Execute: ORACLE - select * from BM_BRXXB0 a,IC_YHXX00 b where a.BRID00=b.BRID00 and b.ZT0000='1' and a.BRXM00 like '测试190216%' and a.BRXB00='男' and a.BRZJBH='1' 160 09:44:34 SQL Execute: ORACLE - Select SYSDATE from Dual 161 09:44:34 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 162 09:44:34 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 163 09:44:34 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') and KLLB00='1' 164 09:44:34 SQL Execute: ORACLE - select Count(*) num,min(ZT0000) ZT0000 from IC_YHXX00 where ICKH00 = 'PTYBPT30100661505' 165 09:44:34 SQL Data In: ORACLE - Param = 1, Name = P_ICKNBH, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100661505 166 09:44:34 SQL Data In: ORACLE - Param = 2, Name = P_ICKH00, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100661505 167 09:44:34 SQL Data In: ORACLE - Param = 3, Name = P_YWCZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 8 168 09:44:34 SQL Data In: ORACLE - Param = 4, Name = P_ICKMM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 169 09:44:34 SQL Data In: ORACLE - Param = 5, Name = P_KLDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = YB-MMRK 170 09:44:34 SQL Data In: ORACLE - Param = 6, Name = P_KMH000, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100661505 171 09:44:34 SQL Data In: ORACLE - Param = 7, Name = P_SFDM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 172 09:44:34 SQL Data In: ORACLE - Param = 8, Name = P_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 173 09:44:34 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 174 09:44:34 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 175 09:44:34 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; 176 09:44:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 35 177 09:44:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3503 178 09:44:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 350303 179 09:44:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 180 09:44:34 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 35,3503,350303,0 181 09:44:34 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 182 09:44:34 SQL Execute: ORACLE - select SF_SF_BRDZBM(?,?,?,?,?,?) FSDYLX from dual 183 09:44:34 SQL Data In: ORACLE - Param = 1, Name = AS_ICKH00, Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100661505 184 09:44:34 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 185 09:44:34 SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = *688403 186 09:44:34 SQL Data In: ORACLE - Param = 4, Name = AS_BRXM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 测试190216 187 09:44:34 SQL Data In: ORACLE - Param = 5, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 188 09:44:34 SQL Data In: ORACLE - Param = 6, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 189 09:44:34 SQL Data In: ORACLE - Param = 7, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19880101 190 09:44:34 SQL Data In: ORACLE - Param = 8, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 191 09:44:34 SQL Data In: ORACLE - Param = 9, Name = AS_BRZY00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 国家机关、党群组织、企业、事业单位负责人 192 09:44:34 SQL Data In: ORACLE - Param = 10, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 193 09:44:34 SQL Data In: ORACLE - Param = 11, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 194 09:44:34 SQL Data In: ORACLE - Param = 12, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 195 09:44:34 SQL Data In: ORACLE - Param = 13, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 196 09:44:34 SQL Data In: ORACLE - Param = 14, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 197 09:44:34 SQL Data In: ORACLE - Param = 15, Name = AS_GFZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 198 09:44:34 SQL Data In: ORACLE - Param = 16, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本市 199 09:44:34 SQL Data In: ORACLE - Param = 17, Name = AS_BRDH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 200 09:44:34 SQL Data In: ORACLE - Param = 18, Name = AS_BRSZSF, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 201 09:44:34 SQL Data In: ORACLE - Param = 19, Name = AS_BRSZS0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 莆田市 202 09:44:34 SQL Data In: ORACLE - Param = 20, Name = AS_BRSZZ0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 涵江区 203 09:44:34 SQL Data In: ORACLE - Param = 21, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 204 09:44:34 SQL Data In: ORACLE - Param = 22, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 205 09:44:34 SQL Data In: ORACLE - Param = 23, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 206 09:44:34 SQL Data In: ORACLE - Param = 24, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 207 09:44:34 SQL Data In: ORACLE - Param = 25, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 208 09:44:34 SQL Data In: ORACLE - Param = 26, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 209 09:44:34 SQL Data In: ORACLE - Param = 27, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 210 09:44:34 SQL Data In: ORACLE - Param = 28, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 211 09:44:34 SQL Data In: ORACLE - Param = 29, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 212 09:44:34 SQL Data In: ORACLE - Param = 30, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 213 09:44:34 SQL Data In: ORACLE - Param = 31, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 初诊 214 09:44:34 SQL Data In: ORACLE - Param = 32, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 215 09:44:34 SQL Data In: ORACLE - Param = 33, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000 216 09:44:34 SQL Data In: ORACLE - Param = 34, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 217 09:44:34 SQL Data In: ORACLE - Param = 35, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 218 09:44:34 SQL Data In: ORACLE - Param = 36, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 219 09:44:34 SQL Data In: ORACLE - Param = 37, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 220 09:44:34 SQL Data In: ORACLE - Param = 38, Name = AS_KL0000, Type = fldZSTRING, Precision = 14, Scale = 0, Data = hplZOq6iScaqyo 221 09:44:34 SQL Data In: ORACLE - Param = 39, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 222 09:44:34 SQL Data In: ORACLE - Param = 40, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 223 09:44:34 SQL Data In: ORACLE - Param = 41, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 224 09:44:34 SQL Data In: ORACLE - Param = 42, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 225 09:44:34 SQL Data In: ORACLE - Param = 43, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 226 09:44:34 SQL Data In: ORACLE - Param = 44, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 管理员csCS 227 09:44:34 SQL Data In: ORACLE - Param = 45, Name = AD_CZYKSH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 51.000000 228 09:44:34 SQL Data In: ORACLE - Param = 46, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 229 09:44:34 SQL Data In: ORACLE - Param = 47, Name = AS_YBKH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 230 09:44:34 SQL Data In: ORACLE - Param = 48, Name = AS_YBID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 231 09:44:34 SQL Data In: ORACLE - Param = 49, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 232 09:44:34 SQL Data In: ORACLE - Param = 50, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 233 09:44:34 SQL Data In: ORACLE - Param = 51, Name = AS_SFSBLF, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 234 09:44:34 SQL Data In: ORACLE - Param = 52, Name = AD_YGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 235 09:44:34 SQL Data In: ORACLE - Param = 53, Name = AD_SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 236 09:44:34 SQL Data In: ORACLE - Param = 54, Name = AS_SFYXJB, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 237 09:44:34 SQL Data In: ORACLE - Param = 55, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 238 09:44:34 SQL Data In: ORACLE - Param = 56, Name = AS_BJJBIE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 239 09:44:34 SQL Data In: ORACLE - Param = 57, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 240 09:44:34 SQL Data In: ORACLE - Param = 58, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 241 09:44:34 SQL Data In: ORACLE - Param = 59, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 242 09:44:34 SQL Data In: ORACLE - Param = 60, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 243 09:44:34 SQL Data In: ORACLE - Param = 61, Name = as_BRDZBM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 244 09:44:34 SQL Execute: ORACLE - BEGIN "SP_SF_BRXX00_REG000" (AS_ICKH00 => :AS_ICKH00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,AS_BRXM00 => :AS_BRXM00,AS_BRXB00 => :AS_BRXB00,AS_BRXX00 => :AS_BRXX00,AS_BRCSRQ => :AS_BRCSRQ,AS_BRHYZK => :AS_BRHYZK,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRGJ00 => :AS_BRGJ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_FBMC00 => :AS_FBMC00,AS_GFZH00 => :AS_GFZH00,AS_BRDYFW => :AS_BRDYFW,AS_BRDH00 => :AS_BRDH00,AS_BRSZSF => :AS_BRSZSF,AS_BRSZS0 => :AS_BRSZS0,AS_BRSZZ0 => :AS_BRSZZ0,AS_BRJTDZ => :AS_BRJTDZ,AS_BRYB00 => :AS_BRYB00,AD_TYDWID => :AD_TYDWID,AS_TYDWMC => :AS_TYDWMC,AS_BRLXGX => :AS_BRLXGX,AS_BRLXXM => :AS_BRLXXM,AS_BRLXDZ => :AS_BRLXDZ,AS_BRLXDH => :AS_BRLXDH,AS_BRZTQK => :AS_BRZTQK,AS_BRJKQK => :AS_BRJKQK,AS_BRLX00 => :AS_BRLX00,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_KL0000 => :AS_KL0000,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKSH => :AD_CZYKSH,AS_YJJXH0 => :AS_YJJXH0,AS_YBKH00 => :AS_YBKH00,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFYB00 => :AS_SFYB00,AS_SFSBLF => :AS_SFSBLF,AD_YGBH00 => :AD_YGBH00,AD_SFYD00 => :AD_SFYD00,AS_SFYXJB => :AS_SFYXJB,PCOMMIT => :PCOMMIT,AS_BJJBIE => :AS_BJJBIE,AD_JZDH00 => :AD_JZDH00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_BRDZBM => :as_BRDZBM); END; 245 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100661505 246 09:44:35 SQL Execute: ORACLE - select BRID00 from ic_yhxx00 where ickh00 = ? and ZT0000=1 247 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 248 09:44:35 SQL Execute: ORACLE - SELECT * FROM VW_SF_BRZFFS WHERE ZFFSBH = ? 249 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 250 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 门诊建档 251 09:44:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 252 09:44:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 253 09:44:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 254 09:44:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 255 09:44:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 256 09:44:35 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 257 09:44:35 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = B 258 09:44:35 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 259 09:44:35 SQL Execute: ORACLE - Select SF_SF_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00 from dual 260 09:44:35 SQL Execute: ORACLE - SELECT B.XMMC00 FROM xt_xtcs00 A,BM_YYSFXM B WHERE TO_NUMBER(A.VALUE0)=B.SFXMID AND A.NAME00='IC_SFDM' 261 09:44:35 SQL Execute: ORACLE - select A.ICKJE0,B.ZYE000 from ic_yhxx00 A,SF_BRZHXX B where ICKH00='PTYBPT30100661505' and A.BRID00=B.BRID00 262 09:44:35 SQL Execute: ORACLE - select BRZJBH,brid00 from BM_BRXXB0 where BRBLH0='*688403' and BRZJLX='身份证' 263 09:44:35 SQL Execute: ORACLE - SELECT a.*,decode('N','Y','补打','N',' ') SFBD00 FROM VW_SF_BRJFXX a where a.DJH000=18894195 264 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 265 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 266 09:44:35 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 267 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 268 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 269 09:44:35 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 270 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 271 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 272 09:44:35 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 273 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 274 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 275 09:44:35 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 276 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 277 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 278 09:44:35 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 279 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 280 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 281 09:44:35 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 282 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 283 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 284 09:44:35 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 285 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 286 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 287 09:44:35 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 288 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 289 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 290 09:44:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 291 09:44:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 292 09:44:35 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 293 09:44:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 294 09:44:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 295 09:44:35 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence