1 16:00:00 SQL Execute: ORACLE - select * from vw_jy_yw0000 where jgzt00 = '2' and yjksbh=46 and BBSDRQ||' '||BBSDSJ between '20150601 00:00:00' and '20150601 23:59:59' and BBSDRQ between '20150601' and '20150601' order by BBSDRQ desc,BBSDSJ desc 2 16:01:34 SQL Execute: ORACLE - select * from vw_jy_yw0000 where jgzt00 in ('2','4','5','6','8') and BBSDRQ||BBSDSJ between '2015060100:00:00' and '2015060123:59:59' and BBSDRQ between '20150601' and '20150601' order by BBSDRQ desc,BBSDSJ desc 3 16:02:37 SQL Execute: ORACLE - select * from vw_jy_yw0000 where jgzt00 in ('2','4','5','6','8') and yjksbh=46 and BBSDRQ||' '||BBSDSJ between '20150601 00:00:00' and '20150601 23:59:59' and BBSDRQ between '20150601' and '20150601' and txm000 = '1800577116' order by BBSDRQ desc,BBSDSJ desc 4 16:17:26 SQL Execute: ORACLE - select * from vw_jy_yw0000 where txm000 = '1800577116' 5 16:20:26 Log started for: 门诊预约挂号管理系统 6 16:20:27 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.16.3.101','y','PrjMZ_YYGH.exe'||'+'||'门诊预约挂号管理系统','702','53618' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 7 16:20:27 SQL Data In: ORACLE - Rows affected = 1 8 16:20:27 SQL Execute: ORACLE - Commit 9 16:20:29 SQL Data In: ORACLE - Rows affected = 0 10 16:20:29 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 16:20:33 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 16:20:33 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 16:20:33 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 16:20:33 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '10.16.3.101','y','PrjMZ_YYGH.exe'||'+'||'门诊预约挂号管理系统','671','45476' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 15 16:20:34 SQL Data In: ORACLE - Rows affected = 1 16 16:20:34 SQL Execute: ORACLE - Commit 17 16:20:34 SQL Data In: ORACLE - Rows affected = 0 18 16:20:34 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='y' 19 16:20:34 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 20 16:20:35 SQL Execute: ORACLE - Select SYSDATE from Dual 21 16:20:35 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 16:20:35 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 23 16:20:36 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='y' 24 16:20:37 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 25 16:20:38 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 26 16:20:41 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1','4') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='y' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 27 16:20:52 Log started for: 检验信息系统 28 16:20:55 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 29 16:20:56 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 30 16:20:56 SQL Execute: ORACLE - update jy_yw0000 set THYY00='重度溶血',jgzt00='3',BBSDRQ='20150601',BBSDSJ='16:20:41',BBSDR0=476,PYRQ00=NULL,YBH000=NULL where txm000 = '1800577116' AND JGZT00 NOT IN ('4','5') 31 16:20:56 SQL Error: ORACLE - ORA-20004: 不明原因出错！ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_JY_YW0000_UPDATE_BBTHTS", line 77 ORA-04088: 触发器 'SD_HOSPITAL.TR_JY_YW0000_UPDATE_BBTHTS' 执行过程中出错 32 16:20:56 SQL Error: ORACLE - Unmapped SQL Error Code: 20004 33 16:20:57 SQL Data In: ORACLE - Rows affected = 0 34 16:46:31 Log started for: 门诊预约挂号管理系统