1 11:00:23 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 2 11:00:23 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:00:23 SQL Misc: ORACLE - Set rowset size 4 11:00:23 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.120','D','Mzhsfz.exe'||'+'||'门诊护士工作站','1233','20018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@888:DA0EAE149D09996EA79567577DAFEB94' from dual 5 11:00:23 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.120','D','Mzhsfz.exe'||'+'||'门诊护士工作站','1233','20018' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@888:DA0EAE149D09996EA79567577DAFEB94' from dual 6 11:00:23 SQL Prepare: ORACLE - Commit 7 11:00:23 SQL Execute: ORACLE - Commit 8 11:00:23 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 11:00:23 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 11:00:23 SQL Misc: ORACLE - Set rowset size 11 11:00:23 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 11:00:23 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 11:00:23 SQL Misc: ORACLE - Set rowset size 14 11:00:23 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='888' and CZBZ00 in ('1') 15 11:00:23 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='888' and CZBZ00 in ('1') 16 11:00:23 SQL Misc: ORACLE - Set rowset size 17 11:00:23 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 11:00:23 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 19 11:00:23 SQL Misc: ORACLE - Set rowset size 20 11:00:24 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.120','D','Mzhsfz.exe'||'+'||'门诊护士工作站','1040','33735' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@888:0FBFEE692369F28AF4AB6E81DF3E98C1' from dual 21 11:00:24 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.120','D','Mzhsfz.exe'||'+'||'门诊护士工作站','1040','33735' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@888:0FBFEE692369F28AF4AB6E81DF3E98C1' from dual 22 11:00:24 SQL Prepare: ORACLE - Commit 23 11:00:24 SQL Execute: ORACLE - Commit 24 11:00:24 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 25 11:00:24 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='D' 26 11:00:24 SQL Misc: ORACLE - Set rowset size 27 11:00:24 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='888' and CZBZ00 in ('1') 28 11:00:24 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='888' and CZBZ00 in ('1') 29 11:00:24 SQL Misc: ORACLE - Set rowset size 30 11:00:24 SQL Prepare: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 31 11:00:24 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='D' 32 11:00:24 SQL Misc: ORACLE - Set rowset size 33 11:00:24 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888')) order by b.PLXH00,a.BH0000 34 11:00:24 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('1') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888')) order by b.PLXH00,a.BH0000 35 11:00:24 SQL Misc: ORACLE - Set rowset size 36 11:00:29 SQL Prepare: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '363' 37 11:00:29 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '363' 38 11:00:29 SQL Misc: ORACLE - Set rowset size 39 11:00:29 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 40 11:00:29 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 41 11:00:29 SQL Misc: ORACLE - Set rowset size 42 11:00:29 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '888'='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)='888')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888') 43 11:00:29 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '888'='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)='888')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='D' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='888') 44 11:00:29 SQL Misc: ORACLE - Set rowset size 45 11:00:29 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1166 46 11:00:29 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1166 47 11:00:29 SQL Misc: ORACLE - Set rowset size 48 11:00:29 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 11:00:29 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 11:00:29 SQL Misc: ORACLE - Set rowset size 51 11:00:29 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4698885 52 11:00:29 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4698885 53 11:00:29 SQL Prepare: ORACLE - Commit 54 11:00:29 SQL Execute: ORACLE - Commit 55 11:00:29 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 56 11:00:29 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 57 11:00:29 SQL Misc: ORACLE - Set rowset size 58 11:00:29 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 59 11:00:29 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 60 11:00:29 SQL Misc: ORACLE - Set rowset size 61 11:00:29 SQL Prepare: 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')) 62 11:00:29 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')) 63 11:00:32 SQL Misc: ORACLE - Set rowset size 64 11:00:32 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4698886,1166,'二楼内科叫号','D',nvl('231398695',' '),'192.168.8.83-192.168.1.120#1040:33735@Mzhsfz.exe+门诊护士工作站',363) 65 11:00:32 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4698886,1166,'二楼内科叫号','D',nvl('231398695',' '),'192.168.8.83-192.168.1.120#1040:33735@Mzhsfz.exe+门诊护士工作站',363) 66 11:00:32 SQL Prepare: ORACLE - Commit 67 11:00:32 SQL Execute: ORACLE - Commit 68 11:00:32 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 363 69 11:00:32 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 363 70 11:00:32 SQL Misc: ORACLE - Set rowset size 71 11:00:32 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 72 11:00:32 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 73 11:00:32 SQL Misc: ORACLE - Set rowset size 74 11:00:32 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 75 11:00:32 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 76 11:00:32 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.120' 77 11:00:32 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.120' 78 11:00:32 SQL Misc: ORACLE - Set rowset size 79 11:00:32 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 80 11:00:32 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 81 11:00:32 SQL Misc: ORACLE - Set rowset size 82 11:00:32 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=161 83 11:00:32 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=161 84 11:00:32 SQL Prepare: ORACLE - Commit 85 11:00:32 SQL Execute: ORACLE - Commit 86 11:00:32 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 363 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,81,0,1),decode(JQBH00,161,0,1),ZT0000 desc,CKBH00 87 11:00:32 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 363 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,81,0,1),decode(JQBH00,161,0,1),ZT0000 desc,CKBH00 88 11:00:32 SQL Misc: ORACLE - Set rowset size 89 11:00:33 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150713' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',363,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='D') 90 11:00:33 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150713' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',363,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='D') 91 11:00:33 SQL Misc: ORACLE - Set rowset size 92 11:00:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 93 11:00:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 94 11:00:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 95 11:00:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 96 11:00:33 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_INPUTBMDIRECT') and YGBH00 = 1166 97 11:00:33 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','YS_YPMRSZ','YS_XSYPSC','YS_ZYGSBL','YS_READONLYCOLOR','YS_INPUTBMDIRECT') and YGBH00 = 1166 98 11:00:33 SQL Misc: ORACLE - Set rowset size 99 11:00:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='D' and (( 1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='D'))) 100 11:00:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='D' and (( 1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='D'))) 101 11:00:33 SQL Misc: ORACLE - Set rowset size 102 11:00:33 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'D$%' and A.XTDM00='D' and trim(A.MKDM00)='D$'||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 103 11:00:33 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'D$%' and A.XTDM00='D' and trim(A.MKDM00)='D$'||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 104 11:00:33 SQL Misc: ORACLE - Set rowset size 105 11:00:33 SQL Prepare: 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 ((1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='0 '))) 106 11:00:33 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 ((1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='0 '))) 107 11:00:33 SQL Misc: ORACLE - Set rowset size 108 11:00:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 109 11:00:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 110 11:00:33 SQL Misc: ORACLE - Set rowset size 111 11:00:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='+ '))) 112 11:00:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1166= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1166 and XTDM00='+ '))) 113 11:00:33 SQL Misc: ORACLE - Set rowset size 114 11:00:36 SQL Prepare: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150713' and GHMZSJ<='20090616' order by GHMZSJ,GHKSBH,GHYSBH 115 11:00:36 SQL Execute: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150713' and GHMZSJ<='20090616' order by GHMZSJ,GHKSBH,GHYSBH 116 11:00:36 SQL Misc: ORACLE - Set rowset size 117 11:00:36 SQL Prepare: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150713' and GHMZSJ<='20150728' order by GHMZSJ,GHKSBH,GHYSBH 118 11:00:36 SQL Execute: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150713' and GHMZSJ<='20150728' order by GHMZSJ,GHKSBH,GHYSBH 119 11:00:37 SQL Misc: ORACLE - Set rowset size 120 11:00:48 SQL Prepare: ORACLE - Select SYSDATE from Dual 121 11:00:48 SQL Execute: ORACLE - Select SYSDATE from Dual 122 11:00:48 SQL Misc: ORACLE - Set rowset size 123 11:00:48 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 124 11:00:48 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 125 11:00:48 SQL Misc: ORACLE - Set rowset size 126 11:00:48 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 127 11:00:48 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 128 11:00:48 SQL Misc: ORACLE - Set rowset size 129 11:00:48 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 130 11:00:48 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 131 11:00:48 SQL Misc: ORACLE - Set rowset size 132 11:00:49 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 133 11:00:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 134 11:00:49 SQL Misc: ORACLE - Set rowset size 135 11:00:49 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 136 11:00:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 137 11:00:49 SQL Misc: ORACLE - Set rowset size 138 11:00:49 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 139 11:00:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 140 11:00:49 SQL Misc: ORACLE - Set rowset size 141 11:00:50 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 142 11:00:50 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 143 11:00:50 SQL Misc: ORACLE - Set rowset size 144 11:00:50 SQL Prepare: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH from vw_ys_brxxb0 a where a.brid00=2025202 145 11:00:50 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH from vw_ys_brxxb0 a where a.brid00=2025202 146 11:00:50 SQL Prepare: ORACLE - Select To_date('19491129','YYYY.MM.DD') from dual 147 11:00:50 SQL Execute: ORACLE - Select To_date('19491129','YYYY.MM.DD') from dual 148 11:00:50 SQL Misc: ORACLE - Set rowset size 149 11:00:50 SQL Prepare: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ from vw_yy_bryyxxcx a where (a.BRID00=:1 or a.BRXM00=:2) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) ) and a.YYZT00 in ('0','1') 150 11:00:50 SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ from vw_yy_bryyxxcx a where (a.BRID00=? or a.BRXM00=?) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) ) and a.YYZT00 in ('0','1') 151 11:00:50 SQL Misc: ORACLE - Set rowset size 152 11:00:56 SQL Prepare: ORACLE - Select SYSDATE from Dual 153 11:00:56 SQL Execute: ORACLE - Select SYSDATE from Dual 154 11:00:56 SQL Misc: ORACLE - Set rowset size 155 11:00:56 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 156 11:00:56 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 157 11:00:56 SQL Misc: ORACLE - Set rowset size 158 11:00:56 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 159 11:00:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 160 11:00:56 SQL Misc: ORACLE - Set rowset size 161 11:00:56 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 162 11:00:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 163 11:00:56 SQL Misc: ORACLE - Set rowset size 164 11:00:56 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 165 11:00:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 166 11:00:56 SQL Misc: ORACLE - Set rowset size 167 11:00:56 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 168 11:00:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 169 11:00:56 SQL Misc: ORACLE - Set rowset size 170 11:00:56 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 171 11:00:56 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 172 11:00:56 SQL Misc: ORACLE - Set rowset size 173 11:00:58 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 174 11:00:58 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 175 11:00:58 SQL Misc: ORACLE - Set rowset size 176 11:00:58 SQL Prepare: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00 from vw_ys_brxxb0 a where a.brid00=2025202 177 11:00:58 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00 from vw_ys_brxxb0 a where a.brid00=2025202 178 11:00:58 SQL Prepare: ORACLE - Update SF_YYBRB0 set BRID00=:1,KMH000=:2,ICKH00=:3 where YYID00=:4 179 11:00:58 SQL Execute: ORACLE - Update SF_YYBRB0 set BRID00=?,KMH000=?,ICKH00=? where YYID00=? 180 11:00:58 SQL Prepare: ORACLE - Update YS_HBHZXH set BRID00=:1,BRXM00=:2,YYID00=:3 where GHHBID=:4 and HZXH00=:5 181 11:00:58 SQL Execute: ORACLE - Update YS_HBHZXH set BRID00=?,BRXM00=?,YYID00=? where GHHBID=? and HZXH00=? 182 11:00:58 SQL Prepare: ORACLE - Update BM_BRXXB0 set BRDH00=:1,BRZJBH=:2 where BRID00=:3 183 11:00:58 SQL Execute: ORACLE - Update BM_BRXXB0 set BRDH00=?,BRZJBH=? where BRID00=? 184 11:00:58 SQL Prepare: ORACLE - Select SYSDATE from Dual 185 11:00:58 SQL Execute: ORACLE - Select SYSDATE from Dual 186 11:00:58 SQL Misc: ORACLE - Set rowset size 187 11:00:58 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 188 11:00:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 189 11:00:58 SQL Misc: ORACLE - Set rowset size 190 11:00:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 191 11:00:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 192 11:00:58 SQL Misc: ORACLE - Set rowset size 193 11:00:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 194 11:00:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 195 11:00:58 SQL Misc: ORACLE - Set rowset size 196 11:00:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 197 11:00:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 198 11:00:58 SQL Misc: ORACLE - Set rowset size 199 11:00:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 200 11:00:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FJYB' and KLDH00 not in ('CK','JMCK') 201 11:00:58 SQL Misc: ORACLE - Set rowset size 202 11:00:58 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 203 11:00:58 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 204 11:00:58 SQL Misc: ORACLE - Set rowset size 205 11:01:00 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 206 11:01:00 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBA49999559' and ICKNBH = 'FZYBA49999559' 207 11:01:00 SQL Misc: ORACLE - Set rowset size 208 11:01:00 SQL Prepare: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH from vw_ys_brxxb0 a where a.brid00=2025202 209 11:01:00 SQL Execute: ORACLE - Select a.BRXB00,a.BRCSRQ,a.BRJTDZ,SF_SF_CSRQTONL(trim(a.BRCSRQ)) BRNL,a.BRXM00,a.BRDH00,a.BRID00, a.KYJE00,a.BRZJBH from vw_ys_brxxb0 a where a.brid00=2025202 210 11:01:00 SQL Prepare: ORACLE - Select To_date('19491129','YYYY.MM.DD') from dual 211 11:01:00 SQL Execute: ORACLE - Select To_date('19491129','YYYY.MM.DD') from dual 212 11:01:00 SQL Misc: ORACLE - Set rowset size 213 11:01:00 SQL Prepare: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ from vw_yy_bryyxxcx a where (a.BRID00=:1 or a.BRXM00=:2) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) ) and a.YYZT00 in ('0','1') 214 11:01:00 SQL Execute: ORACLE - select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1) FZCKBH ,ceil((to_date(TO_char(sysdate, 'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')-to_date(YYRQ00||YYJSSJ,'YYYYMMDD HH24:MI:SS'))* 24 * 60) YYCDSJ from vw_yy_bryyxxcx a where (a.BRID00=? or a.BRXM00=?) and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) ) and a.YYZT00 in ('0','1') 215 11:01:00 SQL Misc: ORACLE - Set rowset size 216 11:01:00 SQL Prepare: ORACLE - BEGIN "SP_YY_YYZYGH_DGBR" (P_BRID00 => :P_BRID00,P_YYID00 => :P_YYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 217 11:01:00 SQL Misc: ORACLE - Set stored procedure on or off 218 11:01:00 SQL Execute: ORACLE - BEGIN "SP_YY_YYZYGH_DGBR" (P_BRID00 => :P_BRID00,P_YYID00 => :P_YYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 219 11:01:00 SQL Prepare: ORACLE - Rollback 220 11:01:00 SQL Execute: ORACLE - Rollback 221 11:02:52 SQL Prepare: ORACLE - rollback 222 11:02:52 SQL Execute: ORACLE - rollback 223 11:02:54 SQL Prepare: ORACLE - BEGIN "SP_YY_YYZYGH_DGBR" (P_BRID00 => :P_BRID00,P_YYID00 => :P_YYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 224 11:02:54 SQL Misc: ORACLE - Set stored procedure on or off 225 11:02:54 SQL Execute: ORACLE - BEGIN "SP_YY_YYZYGH_DGBR" (P_BRID00 => :P_BRID00,P_YYID00 => :P_YYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 226 11:02:54 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_YY_YYZYGH_DGBR", line 92 ORA-01403: 未找到任何数据 ORA-06512: 在 line 1 227 11:02:54 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 228 11:02:54 SQL Prepare: ORACLE - Rollback 229 11:02:54 SQL Execute: ORACLE - Rollback 230 11:03:16 SQL Prepare: ORACLE - rollback 231 11:03:16 SQL Execute: ORACLE - rollback 232 11:03:27 SQL Prepare: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150727' and GHMZSJ<='20150728' order by GHMZSJ,GHKSBH,GHYSBH 233 11:03:27 SQL Execute: ORACLE - select * from VW_YY_PBYSXX where GHMZSJ>='20150727' and GHMZSJ<='20150728' order by GHMZSJ,GHKSBH,GHYSBH 234 11:03:27 SQL Misc: ORACLE - Set rowset size 235 11:03:29 SQL Prepare: ORACLE - Select * from vw_yy_ysjj where YGBH00=:1 236 11:03:29 SQL Execute: ORACLE - Select * from vw_yy_ysjj where YGBH00=? 237 11:03:29 SQL Misc: ORACLE - Set rowset size 238 11:03:29 SQL Prepare: ORACLE - Select * from vw_yy_ysjj where YGBH00=:1 239 11:03:29 SQL Execute: ORACLE - Select * from vw_yy_ysjj where YGBH00=? 240 11:03:29 SQL Misc: ORACLE - Set rowset size 241 11:03:31 SQL Prepare: ORACLE - Select * from vw_yy_ysjj where YGBH00=:1 242 11:03:31 SQL Execute: ORACLE - Select * from vw_yy_ysjj where YGBH00=? 243 11:03:31 SQL Misc: ORACLE - Set rowset size