1 17:14:25 Log started for: Gysystem 2 17:14:25 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110704','17:14:22','scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 17:14:25 SQL Execute: ORACLE - Commit 4 17:14:25 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 5 17:14:25 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 6 17:14:25 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 7 17:14:25 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20110704','17:14:22','sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 8 17:14:25 SQL Execute: ORACLE - Commit 9 17:14:25 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 10 17:14:25 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 17:14:25 SQL Execute: ORACLE - Select SYSDATE from Dual 12 17:14:25 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 13 17:14:25 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 14 17:14:25 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 15 17:14:25 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 17:14:25 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 17 17:14:26 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 18 17:14:35 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 19 17:14:36 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 20 17:14:36 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 17:14:36 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 22 17:14:36 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 23 17:14:36 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 24 17:14:36 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')) 25 17:14:36 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2455473,476,'wlzx-2','F',nvl('7541923',' '),'192.168.15.15#79:4397@GYSystem.exe+供应室管理子系统',15) 26 17:14:36 SQL Execute: ORACLE - Commit 27 17:14:36 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 15 28 17:14:36 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 29 17:14:36 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 30 17:14:36 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 31 17:14:36 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 32 17:14:36 SQL Execute: ORACLE - Commit 33 17:14:36 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 34 17:14:36 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 35 17:14:36 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',15,')> 0) and YXQ000>='20110704' 36 17:14:36 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 37 17:14:36 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 38 17:14:36 SQL Execute: ORACLE - select sysdate from dual 39 17:14:36 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 40 17:14:36 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 41 17:14:36 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 42 17:14:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 43 17:14:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 44 17:14:37 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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 45 17:14:37 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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 46 17:14:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 47 17:14:37 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 48 17:14:37 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 49 17:14:37 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 50 17:14:37 SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX' ) 51 17:14:37 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 52 17:14:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 53 17:14:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 54 17:14:37 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 55 17:14:37 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB' 56 17:14:37 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq000'2' ) order by XKH000,PYSM00) where Rownum<=32 72 17:14:49 SQL Execute: ORACLE - SELECT * FROM vw_gy_kslywh where bmbh00=? ORDER BY WPBH00 73 17:14:50 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ? or WPBH00 Like ?) and( 1=1 AND GYKSBH=150 ) order by WPBH00,PYSM00) where Rownum<=32 74 17:14:51 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 75 17:14:51 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 76 17:14:52 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 77 17:14:52 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 78 17:14:52 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 79 17:14:56 SQL Execute: ORACLE - Select * from (select WPMC00,PYSM00,WBSM00,wpxz00,WPGG00,WPDW00,WPBH00,DQKCL0,WPDJ00,SCPH00,YXQ000,ZHL000 from vw_gy_wpbm00 where (PYSM00 Like ?) and( 1=1 AND GYKSBH=150 ) order by PYSM00) where Rownum<=32 80 17:15:26 SQL Execute: ORACLE - select sq_gy_kswply_qldh00.nextval from dual 81 17:15:26 SQL Execute: ORACLE - insert into GY_KSWPLY(QLDH00,QLKSBH,QLRBH0,QLRQ00,QLSJ00,QLCZY0,ZT0000,FFKSBH) values('47335','150','4','20110704', to_char(sysdate,'HH24:MI:SS'),'476',1,'150') 82 17:15:26 SQL Execute: ORACLE - insert into GY_WPLYMX(ID0000, QLDH00, WPBH00, QLSL00) values(SQ_GY_WPLYMX_ID0000.NextVal, '47335', '48201', '200') 83 17:15:26 SQL Execute: ORACLE - Commit 84 17:15:31 SQL Execute: ORACLE - select * from vw_gy_kswply where (ZT0000=1 OR ZT0000=2 OR ZT0000=3 OR ZT0000=4) AND QLRQ00 BETWEEN ? AND ? AND FFKSBH=? 85 17:15:31 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 86 17:15:31 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 87 17:15:31 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00 88 17:15:31 SQL Execute: ORACLE - select * from vw_gy_wplymx where qldh00=? order by wpxz00