1 15:51:03 SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(11),1,1000)),'') XSPXS0 from dual where rownum=1 2 15:51:06 Log started for: 分诊语音叫号系统 3 15:51:06 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','D','PrjSoundFZJH.exe'||'+'||'分诊语音叫号系统','343','14309' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@999:FDA526D06515D0BF6FD98394CFC53030' from dual 4 15:51:06 SQL Data In: ORACLE - Rows affected = 1 5 15:51:06 SQL Execute: ORACLE - Commit 6 15:51:06 SQL Data In: ORACLE - Rows affected = 0 7 15:51:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 15:51:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142' 9 15:51:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='999' and CZBZ00 in ('1') 10 15:51:06 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 15:51:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.224','D','PrjSoundFZJH.exe'||'+'||'分诊语音叫号系统','347','17462' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@999:05181C48673336CCDBA852B9C5816ED3' from dual 12 15:51:06 SQL Data In: ORACLE - Rows affected = 1 13 15:51:06 SQL Execute: ORACLE - Commit 14 15:51:06 SQL Data In: ORACLE - Rows affected = 0 15 15:51:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 16 15:51:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='999' and CZBZ00 in ('1') 17 15:51:06 SQL Execute: ORACLE - Select SYSDATE from Dual 18 15:51:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 15:51:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 20 15:51:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 15:51: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 22 15:51:06 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','1','2','3','4','5','6','7','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='999')) order by BH0000 23 15:51:06 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'D' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='999')) 24 15:51:06 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1441 25 15:51:06 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc,Length(trim(YYID00)) desc 26 15:51:06 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 15:51:06 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 15:51:06 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 15:51: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')) 30 15:51:06 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1323683,1441,'PDJH-LED','D',nvl('4052541',' '),'192.168.6.224#347:17462@PrjSoundFZJH.exe+分诊语音叫号系统',474) 31 15:51:06 SQL Data In: ORACLE - Rows affected = 1 32 15:51:06 SQL Execute: ORACLE - Commit 33 15:51:06 SQL Data In: ORACLE - Rows affected = 0 34 15:51:06 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 474 35 15:51:06 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 36 15:51:06 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222142' 37 15:51:06 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 38 15:51:06 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.6.224' 39 15:51:06 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 40 15:51:06 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 41 15:51:06 SQL Data In: ORACLE - Rows affected = 0 42 15:51:06 SQL Execute: ORACLE - Commit 43 15:51:06 SQL Data In: ORACLE - Rows affected = 0 44 15:51:06 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000,FSBYJ0 from BM_CKBM00 where BMBH00= 474 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 45 15:51:07 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222142') 46 15:51:07 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'D'||',')>0 47 15:51:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('MZHS_ZSJHLX','YS_HSZJJCL','YS_FZJMXSYGSJD','MZHS_HZBRJHFA','MZHS_JZBRJHCS', 'MZHS_HZBRJHCS ', 'MZHS_HZBRJHJGSJ','MZHS_BRJHLX') 48 15:51:08 SQL Execute: ORACLE - Select t1.SCKBH0,t1.DCKBH0,t2.ckmc00 as sckmc0,t3.ckmc00 as dckmc0,t3.bmbh00, t4.bmmc00,t4.BH0000 from BM_CKDY00 t1,bm_ckbm00 t2, bm_ckbm00 t3, bm_bmbm00 t4 where t1.sckbh0=t2.ckbh00 and t3.bmbh00=t4.bmbh00 and t2.flag00='0' and t1.dckbh0=t3.ckbh00 and t2.bmbh00='569' and t1.SCKBH0='8' 49 15:51:08 SQL Execute: ORACLE - SELECT * FROM ( SELECT C.JHCKBH,A.*,C.CKBH00,NVL(trim(C.BZ0000),C.CKMC00) CKMC00,SUBSTR(A.NL0000,1,16) NL0001,(SELECT LBMC00 FROM BM_GHLBB0 WHERE LBBH00=A.GHLB00) GHLBMC,replace(e.ZKMC00,'其他','') ZKMC00,B.HZQSXH FROM VW_YS_HZBR00_JH A,SF_YSGHHB B, BM_CKBM00 c,BM_ZKBM00 e where B.GHHZCK in (13,14,15,16,18,19,20,22,23,24,26,34,35) and nvl(a.DLXH00,0)>0 and nvl(a.hzxh00,0)>0 and A.HZZT00='4' and A.YSPBID=B.GHHBID and a.SJHZCK=C.CKBH00 and C.FLAG00='4' and ( (A.JHCS00=0 and nvl(A.BJBZ00,'0')='0') or (nvl(A.BJBZ00,'0')='1')) and B.GHZKBH=e.ZKBM00(+) ) ORDER BY JZYS00, DLXH00