1 09:12:06 Log started for: 检验信息系统 2 09:12:06 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 09:12:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 09:12:06 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','108','27659' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@4005:566E2B2892CF233A9E63D65212BF32F5' from dual 5 09:12:06 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','108','27659' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@4005:566E2B2892CF233A9E63D65212BF32F5' from dual 6 09:12:06 SQL Data In: ORACLE - Rows affected = 1 7 09:12:06 SQL Prepare: ORACLE - Commit 8 09:12:06 SQL Execute: ORACLE - Commit 9 09:12:06 SQL Data In: ORACLE - Rows affected = 0 10 09:12:06 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 09:12:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 09:12:06 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 09:12:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 09:12:06 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4005' and CZBZ00 in ('1') 15 09:12:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4005' and CZBZ00 in ('1') 16 09:12:06 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 09:12:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 09:12:06 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','40','17124' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@4005:DC638FFFDAFEC59C35F5DF9660FB0FA4' from dual 19 09:12:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','40','17124' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@4005:DC638FFFDAFEC59C35F5DF9660FB0FA4' from dual 20 09:12:06 SQL Data In: ORACLE - Rows affected = 1 21 09:12:06 SQL Prepare: ORACLE - Commit 22 09:12:06 SQL Execute: ORACLE - Commit 23 09:12:06 SQL Data In: ORACLE - Rows affected = 0 24 09:12:06 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 25 09:12:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 26 09:12:06 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4005' and CZBZ00 in ('1') 27 09:12:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4005' and CZBZ00 in ('1') 28 09:12:06 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 09:12:06 SQL Execute: ORACLE - Select SYSDATE from Dual 30 09:12:06 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 09:12:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 09:12:06 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 09:12:06 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 09:12:06 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 35 09:12:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 36 09:12:06 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 09:12:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 09:12:06 SQL Prepare: 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 39 09:12:06 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 40 09:12:06 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) order by b.PLXH00,a.BH0000 41 09:12:06 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) order by b.PLXH00,a.BH0000 42 09:12:06 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '4005'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005') 43 09:12:06 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '4005'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4005') 44 09:12:06 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=436 45 09:12:06 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=436 46 09:12:06 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 09:12:06 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 09:12:06 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 09:12:06 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 09:12:06 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 09:12:06 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 09:12:06 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 09:12:06 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 09:12:06 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 55 09:12:06 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 56 09:12:06 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3946797,436,'门诊检验科尿检','J',nvl('226947157',' '),'192.168.12.67#40:17124@PrjLIS_LIS.exe+检 验 管 理 系 统',46) 57 09:12:06 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3946797,436,'门诊检验科尿检','J',nvl('226947157',' '),'192.168.12.67#40:17124@PrjLIS_LIS.exe+检 验 管 理 系 统',46) 58 09:12:06 SQL Data In: ORACLE - Rows affected = 1 59 09:12:06 SQL Prepare: ORACLE - Commit 60 09:12:06 SQL Execute: ORACLE - Commit 61 09:12:06 SQL Data In: ORACLE - Rows affected = 0 62 09:12:06 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46 63 09:12:06 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46 64 09:12:06 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 09:12:06 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 09:12:06 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 09:12:06 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 09:12:06 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.67' 69 09:12:06 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.67' 70 09:12:06 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 09:12:06 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 09:12:06 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 46 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 09:12:06 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 46 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 09:12:06 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 09:12:06 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 09:12:06 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 77 09:12:06 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 78 09:12:08 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='436' and name00='SYSTEMSKIN' 79 09:12:08 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='436' and name00='SYSTEMSKIN' 80 09:12:08 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 09:12:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 09:12:08 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140115' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',46,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 83 09:12:08 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140115' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',46,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 84 09:12:08 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 09:12:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 09:12:08 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 09:12:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 09:12:08 SQL Prepare: ORACLE - select sysdate from dual 89 09:12:08 SQL Execute: ORACLE - select sysdate from dual 90 09:12:08 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 436 91 09:12:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 436 92 09:12:08 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 93 09:12:08 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 94 09:12:08 SQL Prepare: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 46 95 09:12:08 SQL Execute: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 46 96 09:12:08 SQL Prepare: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 97 09:12:08 SQL Execute: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 98 09:12:08 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 99 09:12:08 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 100 09:12:08 SQL Prepare: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 101 09:12:08 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 102 09:12:08 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='J'))) 103 09:12:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='J'))) 104 09:12:08 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||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 105 09:12:08 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||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 106 09:12:08 SQL Prepare: 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 ((436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='0 '))) 107 09:12:08 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 ((436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='0 '))) 108 09:12:08 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 109 09:12:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 110 09:12:08 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='+ '))) 111 09:12:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 436= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=436 and XTDM00='+ '))) 112 09:12:17 Log started for: 检验联机数据采集系统自动登录 113 09:12:17 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','j',trim(PROGRAM)||'+'||'检验联机数据采集系统自动登录',SID,serial# ,'20140115','09:12:16','scott@4029:8C338C83F27B976E6F3B76B04E404B66' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 114 09:12:17 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','j',trim(PROGRAM)||'+'||'检验联机数据采集系统自动登录',SID,serial# ,'20140115','09:12:16','scott@4029:8C338C83F27B976E6F3B76B04E404B66' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 115 09:12:17 SQL Data In: ORACLE - Rows affected = 1 116 09:12:17 SQL Prepare: ORACLE - Commit 117 09:12:17 SQL Execute: ORACLE - Commit 118 09:12:17 SQL Data In: ORACLE - Rows affected = 0 119 09:12:17 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 120 09:12:17 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 121 09:12:17 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 122 09:12:17 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 123 09:12:17 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4029' and CZBZ00 in ('1') 124 09:12:17 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4029' and CZBZ00 in ('1') 125 09:12:17 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','j',trim(PROGRAM)||'+'||'检验联机数据采集系统自动登录',SID,serial# ,'20140115','09:12:16','sd_Hospital@4029:8C338C83F27B976E6F3B76B04E404B66' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 126 09:12:17 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.67','j',trim(PROGRAM)||'+'||'检验联机数据采集系统自动登录',SID,serial# ,'20140115','09:12:16','sd_Hospital@4029:8C338C83F27B976E6F3B76B04E404B66' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 127 09:12:17 SQL Data In: ORACLE - Rows affected = 1 128 09:12:17 SQL Prepare: ORACLE - Commit 129 09:12:17 SQL Execute: ORACLE - Commit 130 09:12:17 SQL Data In: ORACLE - Rows affected = 0 131 09:12:17 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 132 09:12:17 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 133 09:12:18 SQL Data In: ORACLE - Rows affected = 500 134 09:12:18 SQL Prepare: ORACLE - Commit 135 09:12:18 SQL Execute: ORACLE - Commit 136 09:12:18 SQL Data In: ORACLE - Rows affected = 0 137 09:12:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='j' 138 09:12:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='j' 139 09:12:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4029' and CZBZ00 in ('1') 140 09:12:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4029' and CZBZ00 in ('1') 141 09:12:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 142 09:12:18 SQL Execute: ORACLE - Select SYSDATE from Dual 143 09:12:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 144 09:12:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 145 09:12:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 146 09:12:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 147 09:12:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='j' 148 09:12:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='j' 149 09:12:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 150 09:12:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 151 09:12:18 SQL Prepare: 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 152 09:12:18 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 153 09:12:18 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='j' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='j' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) order by b.PLXH00,a.BH0000 154 09:12:18 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='j' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='j' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) order by b.PLXH00,a.BH0000 155 09:12:18 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '4029'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'j' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) 156 09:12:18 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '4029'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'j' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4029')) 157 09:12:18 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=881 158 09:12:18 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=881 159 09:12:18 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 160 09:12:18 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 161 09:12:18 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 162 09:12:18 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 163 09:12:18 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 164 09:12:18 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 165 09:12:18 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 166 09:12:18 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 167 09:12:18 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 168 09:12:18 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 SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 169 09:12:18 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3946798,881,'门诊检验科尿检','j',nvl('226947163',' '),'192.168.12.67#181:53927@ProjectCheck.exe+检验联机数据采集系统自动登录',46) 170 09:12:18 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3946798,881,'门诊检验科尿检','j',nvl('226947163',' '),'192.168.12.67#181:53927@ProjectCheck.exe+检验联机数据采集系统自动登录',46) 171 09:12:18 SQL Data In: ORACLE - Rows affected = 1 172 09:12:18 SQL Prepare: ORACLE - Commit 173 09:12:18 SQL Execute: ORACLE - Commit 174 09:12:18 SQL Data In: ORACLE - Rows affected = 0 175 09:12:18 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46 176 09:12:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 46 177 09:12:18 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 178 09:12:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 179 09:12:18 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.67' 180 09:12:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.67' 181 09:12:18 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 182 09:12:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 183 09:12:18 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 46 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 184 09:12:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 46 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 185 09:12:18 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 186 09:12:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 187 09:12:18 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='881' and name00='SYSTEMSKIN' 188 09:12:18 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='881' and name00='SYSTEMSKIN' 189 09:12:18 SQL Prepare: ORACLE - SELECT YQDH00,YQMC00,COMID0,BTL000,SJW000,JYW000,TZW000,SFTMSX FROM JY_JYYQZD WHERE YQDH00='UT' 190 09:12:18 SQL Execute: ORACLE - SELECT YQDH00,YQMC00,COMID0,BTL000,SJW000,JYW000,TZW000,SFTMSX FROM JY_JYYQZD WHERE YQDH00='UT' 191 09:12:18 SQL Prepare: ORACLE - SELECT DISTINCT DECODE(FSBZ00,'N','N','Y') XZBZ00,FSBZ00, YBH000,BRXM00, XBMC00,YQDH00,BBID00,PYRQ00,SECTOR,CUPNUM,TXM000,YXBZ00 FROM VW_JY_JGCL00 WHERE YQDH00='UT' and JGLX00<>'C' and BGRQ00 is null and JYJG00 is null and pyrq00=TO_CHAR(sysdate,'yyyymmdd') and FSBZ00='N' ORDER BY FSBZ00,YBH000 192 09:12:18 SQL Execute: ORACLE - SELECT DISTINCT DECODE(FSBZ00,'N','N','Y') XZBZ00,FSBZ00, YBH000,BRXM00, XBMC00,YQDH00,BBID00,PYRQ00,SECTOR,CUPNUM,TXM000,YXBZ00 FROM VW_JY_JGCL00 WHERE YQDH00='UT' and JGLX00<>'C' and BGRQ00 is null and JYJG00 is null and pyrq00=TO_CHAR(sysdate,'yyyymmdd') and FSBZ00='N' ORDER BY FSBZ00,YBH000 193 09:12:18 SQL Prepare: ORACLE - SELECT DISTINCT SECTOR,CUPNUM FROM VW_JY_JGCL00 WHERE pyrq00=TO_CHAR(sysdate,'yyyymmdd') AND FSBZ00='Y' and JGLX00<>'C' AND YQDH00='UT' and BGRQ00 is null 194 09:12:18 SQL Execute: ORACLE - SELECT DISTINCT SECTOR,CUPNUM FROM VW_JY_JGCL00 WHERE pyrq00=TO_CHAR(sysdate,'yyyymmdd') AND FSBZ00='Y' and JGLX00<>'C' AND YQDH00='UT' and BGRQ00 is null