1 16:22:15 Log started for: 分诊语音叫号系统 2 16:22:15 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 16:22:15 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.16.214.1','D','PrjSoundFZJH.exe'||'+'||'分诊语音叫号系统','129','35428' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9999:DA0EAE149D09996EA79567577DAFEB94' from dual 4 16:22:15 SQL Data In: ORACLE - Rows affected = 1 5 16:22:15 SQL Execute: ORACLE - Commit 6 16:22:15 SQL Data In: ORACLE - Rows affected = 0 7 16:22:15 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 16:22:15 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 16:22:15 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 10 16:22:15 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 16:22:15 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.16.214.1','D','PrjSoundFZJH.exe'||'+'||'分诊语音叫号系统','132','18341' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9999:CC0412A9DAAA304AE8CC58EE75232FAB' from dual 12 16:22:15 SQL Data In: ORACLE - Rows affected = 1 13 16:22:15 SQL Execute: ORACLE - Commit 14 16:22:15 SQL Data In: ORACLE - Rows affected = 0 15 16:22:15 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 16 16:22:15 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 17 16:22:15 SQL Execute: ORACLE - Select SYSDATE from Dual 18 16:22:15 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 16:22:15 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 20 16:22:15 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 16:22:15 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 16:22:15 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1') 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)='9999')) order by BH0000 23 16:22:23 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='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)='9999')) 24 16:22:23 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=369 25 16:22:23 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 16:22:23 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 16:22:23 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 16:22:23 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 16:22:23 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 16:22:23 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2965205,369,'LP-PC','D',nvl('14266951',' '),'10.16.3.17-172.16.214.1#132:18341@PrjSoundFZJH.exe+分诊语音叫号系统',112) 31 16:22:23 SQL Data In: ORACLE - Rows affected = 1 32 16:22:23 SQL Execute: ORACLE - Commit 33 16:22:23 SQL Data In: ORACLE - Rows affected = 0 34 16:22:23 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 112 35 16:22:23 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 36 16:22:23 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 37 16:22:23 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 38 16:22:23 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='172.16.214.1' 39 16:22:23 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 40 16:22:23 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 41 16:22:23 SQL Data In: ORACLE - Rows affected = 0 42 16:22:23 SQL Execute: ORACLE - Commit 43 16:22:23 SQL Data In: ORACLE - Rows affected = 0 44 16:22:23 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 112 and FLAG00 like '%' order by decode(CKBH00,5,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 45 16:22:24 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 46 16:22:24 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'D'||',')>0 47 16:22:27 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 48 16:22:27 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='D') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',112,')> 0) and YXQ000>='20181119' 49 16:22:27 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 50 16:22:27 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 51 16:22:27 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') 52 16:22:27 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='112' and t1.SCKBH0='165' 53 16:22:27 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 FROM VW_YS_HZBR00 A,SF_YSGHHB B, BM_CKBM00 c,BM_ZKBM00 e where B.GHHZCK in (166,446) and a.DLXH00>0 and A.HZZT00='4' and A.YSPBID=B.GHHBID and B.GHHZCK=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(+) union all 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,'' ZKMC00 FROM VW_YS_HZBR00 A, SF_YSGHHB B, BM_CKBM00 c where B.GHHZCK in (166,446) and a.dlxh00 > 0 and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4' and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, BM_CKBM00 K where I.GHHZCK in (166,446) and H.DLXH00 > 0 and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' and ( (H.JHCS00=0 and nvl(H.BJBZ00,'0')='0') or (nvl(H.BJBZ00,'0')='1'))) and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE F.GHHZCK in (166,446) and E.DLXH00 > 0 and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID) ) ORDER BY JZYS00, DLXH00 54 16:22:27 SQL Error: ORACLE - ORA-00918: 未明确定义列 55 16:22:27 SQL Error: ORACLE - Unmapped SQL Error Code: 918 56 16:22:27 SQL Data In: ORACLE - Rows affected = 0 57 16:22:35 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='112' and t1.SCKBH0='165' 58 16:22:35 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 FROM VW_YS_HZBR00 A,SF_YSGHHB B, BM_CKBM00 c,BM_ZKBM00 e where B.GHHZCK in (166,446) and a.DLXH00>0 and A.HZZT00='4' and A.YSPBID=B.GHHBID and B.GHHZCK=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(+) union all 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,'' ZKMC00 FROM VW_YS_HZBR00 A, SF_YSGHHB B, BM_CKBM00 c where B.GHHZCK in (166,446) and a.dlxh00 > 0 and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4' and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, BM_CKBM00 K where I.GHHZCK in (166,446) and H.DLXH00 > 0 and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' and ( (H.JHCS00=0 and nvl(H.BJBZ00,'0')='0') or (nvl(H.BJBZ00,'0')='1'))) and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE F.GHHZCK in (166,446) and E.DLXH00 > 0 and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID) ) ORDER BY JZYS00, DLXH00 59 16:22:35 SQL Error: ORACLE - ORA-00918: 未明确定义列 60 16:22:35 SQL Error: ORACLE - Unmapped SQL Error Code: 918 61 16:22:35 SQL Data In: ORACLE - Rows affected = 0 62 16:22:36 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='112' and t1.SCKBH0='165' 63 16:22:36 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 FROM VW_YS_HZBR00 A,SF_YSGHHB B, BM_CKBM00 c,BM_ZKBM00 e where B.GHHZCK in (166,446) and a.DLXH00>0 and A.HZZT00='4' and A.YSPBID=B.GHHBID and B.GHHZCK=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(+) union all 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,'' ZKMC00 FROM VW_YS_HZBR00 A, SF_YSGHHB B, BM_CKBM00 c where B.GHHZCK in (166,446) and a.dlxh00 > 0 and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4' and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, BM_CKBM00 K where I.GHHZCK in (166,446) and H.DLXH00 > 0 and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' and ( (H.JHCS00=0 and nvl(H.BJBZ00,'0')='0') or (nvl(H.BJBZ00,'0')='1'))) and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE F.GHHZCK in (166,446) and E.DLXH00 > 0 and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID) ) ORDER BY JZYS00, DLXH00 64 16:22:36 SQL Error: ORACLE - ORA-00918: 未明确定义列 65 16:22:36 SQL Error: ORACLE - Unmapped SQL Error Code: 918 66 16:22:36 SQL Data In: ORACLE - Rows affected = 0 67 16:22:37 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='112' and t1.SCKBH0='165' 68 16:22:37 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 FROM VW_YS_HZBR00 A,SF_YSGHHB B, BM_CKBM00 c,BM_ZKBM00 e where B.GHHZCK in (166,446) and a.DLXH00>0 and A.HZZT00='4' and A.YSPBID=B.GHHBID and B.GHHZCK=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(+) union all 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,'' ZKMC00 FROM VW_YS_HZBR00 A, SF_YSGHHB B, BM_CKBM00 c where B.GHHZCK in (166,446) and a.dlxh00 > 0 and A.HZZT00 = '0' and A.YSPBID = B.GHHBID and B.GHHZCK = C.CKBH00 and C.FLAG00 = '4' and A.YSPBID in (SELECT H.YSPBID FROM VW_YS_HZBR00 H, SF_YSGHHB I, BM_CKBM00 K where I.GHHZCK in (166,446) and H.DLXH00 > 0 and H.HZZT00 = '4' and H.YSPBID = I.GHHBID and I.GHHZCK = K.CKBH00 and K.FLAG00 = '4' and ( (H.JHCS00=0 and nvl(H.BJBZ00,'0')='0') or (nvl(H.BJBZ00,'0')='1'))) and A.DLXH00 in (SELECT min(E.DLXH00)FROM VW_YS_HZBR00 E, SF_YSGHHB F, BM_CKBM00 D WHERE F.GHHZCK in (166,446) and E.DLXH00 > 0 and E.HZZT00 = '0' and E.YSPBID = F.GHHBID and F.GHHZCK = D.CKBH00 and D.FLAG00 = '4' and E.YSPBID = A.YSPBID) ) ORDER BY JZYS00, DLXH00 69 16:22:37 SQL Error: ORACLE - ORA-00918: 未明确定义列 70 16:22:37 SQL Error: ORACLE - Unmapped SQL Error Code: 918 71 16:22:37 SQL Data In: ORACLE - Rows affected = 0 72 16:22:59 Log started for: 易联众医院信息综合管理平台