1 14:35:10 Log started for: 药房管理系统 2 14:35:10 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20110609','14:35:11','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 14:35:10 SQL Execute: ORACLE - Commit 4 14:35:10 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 5 14:35:10 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 6 14:35:10 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 7 14:35:10 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20110609','14:35:11','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 8 14:35:10 SQL Execute: ORACLE - Commit 9 14:35:10 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 10 14:35:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 14:35:10 SQL Execute: ORACLE - Select SYSDATE from Dual 12 14:35:10 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 13 14:35:10 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 14 14:35:10 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 14:35:10 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 16 14:35:10 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 17 14:35:16 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 18 14:35:16 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 19 14:35:16 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 20 14:35:16 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 21 14:35:16 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 22 14:35:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 23 14:35:16 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')) 24 14:35:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2591299,476,'wlzx-2','2',nvl('4094435',' '),'192.168.15.15#580:23979@appYP_YF.exe+药房管理系统',70) 25 14:35:16 SQL Execute: ORACLE - Commit 26 14:35:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 70 27 14:35:16 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 28 14:35:16 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 29 14:35:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 30 14:35:16 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 70 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 31 14:35:16 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 32 14:35:16 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20110609' 33 14:35:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 34 14:35:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 35 14:35:16 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 36 14:35:16 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 37 14:35:16 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 38 14:35:16 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=70 39 14:35:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 40 14:35:16 SQL Execute: ORACLE - select * from XT_XTCS00 41 14:35:18 SQL Execute: ORACLE - select * from BM_YPLB00 42 14:35:18 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 43 14:35:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 44 14:35:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 14:35:18 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 14:35:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 47 14:35:18 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 14:35:18 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 49 14:35:18 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=70 AND YKKCSL'0' 50 14:35:20 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=70 and X.SFQR00='N' and T.SFQR00='Y' 51 14:35:23 SQL Execute: ORACLE - SELECT FBBH00,FBMC00 FROM BM_BRFBB0 WHERE SFYX00 ='Y' 52 14:35:23 SQL Execute: ORACLE - Select SQ_XT_CDJCRZ_LSH000.NextVal SID from Dual 53 14:35:23 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 54 14:35:23 SQL Execute: ORACLE - Insert into XT_CDJCRZ(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,IP0000, CDMC00,DLRQ00,DLSJ00) Values(23191,476,'wlzx-2','2',nvl('4094435',' '),'192.168.15.15','门诊处方查询',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 55 14:35:23 SQL Execute: ORACLE - Commit 56 14:35:29 SQL Execute: ORACLE - SELECT C.CFLSH0,C.GHH000,C.BRXM00,B.BRBLH0,C.XB0000, C.CSRQ00,DECODE('Y','Y',C.YSXM00,DECODE(SRRQ00,TO_CHAR(SYSDATE,'YYYYMMDD'),C.YSXM00,' ')) YSXM00, M.BMMC00 AS GHKS00,C.ZYTS00,F.FBMC00,C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH, C.DJH000,C.FYRQ00,C.FYSJ00,G.ZWXM00 AS LRY000,C.ZYDJS0, C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,H.ZWXM00 AS FYR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, (SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, NVL(C.CFDGS0,'5') CFDGS0 FROM BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F WHERE C.YFBMBH+0=70 AND C.FYRQ00>='20110608' AND C.FYRQ00<='20110608' AND C.CFZT00 like '2%' AND C.CFXZ00='0' AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00(+) AND C.BRID00=B.BRID00 AND C.BRID00=F.BRID00 AND C.GHH000=F.GHH000 AND C.FYR000=H.YGBH00(+) ORDER BY C.CFZT00,C.CFLSH0 57 14:35:30 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 58 14:35:30 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 59 14:35:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19510826) AS NL FROM DUAL 60 14:35:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19510826) AS NL FROM DUAL 61 14:35:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19510826) AS NL FROM DUAL 62 14:35:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19420119) AS NL FROM DUAL 63 14:35:41 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 64 14:35:41 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19510826) AS NL FROM DUAL 65 14:35:41 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19510826) AS NL FROM DUAL 66 14:35:49 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 67 14:35:49 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 68 14:35:49 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 69 14:35:49 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490325) AS NL FROM DUAL 70 14:35:53 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490325) AS NL FROM DUAL 71 14:36:01 SQL Execute: ORACLE - Update YF_MZCF00 set CFBDCS=NVL(CFBDCS,0)+1 Where CFLSH0='3806249' 72 14:36:01 SQL Execute: ORACLE - commit 73 14:36:01 SQL Execute: ORACLE - delete from yf_cflsh0 74 14:36:01 SQL Execute: ORACLE - insert into yf_cflsh0 values('3806249') 75 14:36:01 SQL Execute: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY where CFLSH0='3806249' and CFID00>0 order by CFID00 76 14:36:01 SQL Execute: ORACLE - select CEIL(COUNT(1)/8) PAGE00,COUNT(1) COUNT0 from VW_YF_MZXYDY where CFLSH0='3806249' and CFID00>0 77 14:36:01 SQL Execute: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY Where (CFLSH0='-1' or CFLSH0='3806249') and CFID00<=0 ORDER BY CFID00 DESC 78 14:36:01 SQL Execute: ORACLE - select CEIL(2/8) PAGE00 from dual