1 11:14:10 Log started for: 住院医生工作站系统 2 11:14:10 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 11:14:10 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 11:14:10 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:10','scott@7778:6753DDE3A1DE08A697E184AD17DB3CA3' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 11:14:10 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:10','scott@7778:6753DDE3A1DE08A697E184AD17DB3CA3' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 6 11:14:10 SQL Data In: ORACLE - Rows affected = 1 7 11:14:10 SQL Prepare: ORACLE - Commit 8 11:14:10 SQL Execute: ORACLE - Commit 9 11:14:10 SQL Data In: ORACLE - Rows affected = 0 10 11:14:10 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 11:14:10 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 11:14:10 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 13 11:14:10 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 14 11:14:10 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 15 11:14:10 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 16 11:14:10 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:10','sd_hospital@7778:84391F02D49591C95796CB931B4B5829' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 17 11:14:10 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:10','sd_hospital@7778:84391F02D49591C95796CB931B4B5829' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 18 11:14:10 SQL Data In: ORACLE - Rows affected = 1 19 11:14:10 SQL Prepare: ORACLE - Commit 20 11:14:10 SQL Execute: ORACLE - Commit 21 11:14:10 SQL Data In: ORACLE - Rows affected = 0 22 11:14:10 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 23 11:14:10 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 24 11:14:10 SQL Data In: ORACLE - Rows affected = 0 25 11:14:10 SQL Prepare: ORACLE - Commit 26 11:14:10 SQL Execute: ORACLE - Commit 27 11:14:10 SQL Data In: ORACLE - Rows affected = 0 28 11:14:10 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 29 11:14:10 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 30 11:14:10 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 31 11:14:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 32 11:14:12 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 33 11:14:12 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 34 11:14:12 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:12','scott@7778:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 35 11:14:12 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:12','scott@7778:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 36 11:14:12 SQL Data In: ORACLE - Rows affected = 1 37 11:14:12 SQL Prepare: ORACLE - Commit 38 11:14:12 SQL Execute: ORACLE - Commit 39 11:14:12 SQL Data In: ORACLE - Rows affected = 0 40 11:14:12 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 41 11:14:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 42 11:14:12 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 43 11:14:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221094' 44 11:14:12 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 45 11:14:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 46 11:14:12 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:12','sd_hospital@7778:DE004E8E44014B94AE601D0B20B30286' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 47 11:14:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.223','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20110808','11:14:12','sd_hospital@7778:DE004E8E44014B94AE601D0B20B30286' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 48 11:14:12 SQL Data In: ORACLE - Rows affected = 1 49 11:14:12 SQL Prepare: ORACLE - Commit 50 11:14:12 SQL Execute: ORACLE - Commit 51 11:14:12 SQL Data In: ORACLE - Rows affected = 0 52 11:14:12 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 53 11:14:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 54 11:14:12 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 55 11:14:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 56 11:14:12 SQL Prepare: ORACLE - Select SYSDATE from Dual 57 11:14:12 SQL Execute: ORACLE - Select SYSDATE from Dual 58 11:14:12 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 59 11:14:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 60 11:14:12 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 61 11:14:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 62 11:14:12 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 63 11:14:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 64 11:14:12 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 65 11:14:12 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 66 11:14:12 SQL Prepare: 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 67 11:14:12 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 68 11:14:12 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) order by b.PLXH00,a.BH0000 69 11:14:12 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3','0') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) order by b.PLXH00,a.BH0000 70 11:14:13 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '7778'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'Z' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778') 71 11:14:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '7778'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'Z' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778') 72 11:14:13 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=952 73 11:14:13 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=952 74 11:14:13 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 75 11:14:13 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 76 11:14:13 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 77 11:14:13 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 78 11:14:13 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 79 11:14:13 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 80 11:14:13 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 81 11:14:13 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 82 11:14:13 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')) 83 11:14:13 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')) 84 11:14:13 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2427768,952,'20110401-1100','Z',nvl('154086',' '),'192.168.1.223#20:35@+住院医生工作站系统',66) 85 11:14:13 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2427768,952,'20110401-1100','Z',nvl('154086',' '),'192.168.1.223#20:35@+住院医生工作站系统',66) 86 11:14:13 SQL Data In: ORACLE - Rows affected = 1 87 11:14:13 SQL Prepare: ORACLE - Commit 88 11:14:13 SQL Execute: ORACLE - Commit 89 11:14:13 SQL Data In: ORACLE - Rows affected = 0 90 11:14:13 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 66 91 11:14:13 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 66 92 11:14:13 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221094' 93 11:14:13 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221094' 94 11:14:13 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 95 11:14:13 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 96 11:14:13 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.223' 97 11:14:13 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.223' 98 11:14:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 99 11:14:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 100 11:14:13 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 66 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 101 11:14:13 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 66 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 102 11:14:13 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 103 11:14:13 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 104 11:14:13 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 105 11:14:13 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 106 11:14:14 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='952' and name00='SYSTEMSKIN' 107 11:14:14 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='952' and name00='SYSTEMSKIN' 108 11:14:14 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 109 11:14:14 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 110 11:14:14 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20110808' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',66,' )>0 ) 111 11:14:14 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20110808' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',66,' )>0 ) 112 11:14:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 113 11:14:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 114 11:14:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 115 11:14:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 116 11:14:14 SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 117 11:14:14 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 118 11:14:14 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 119 11:14:14 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 120 11:14:14 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 121 11:14:14 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 122 11:14:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='Z'))) 123 11:14:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='Z'))) 124 11:14:14 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||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 125 11:14:14 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||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 126 11:14:14 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 ((952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='0 '))) 127 11:14:14 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 ((952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='0 '))) 128 11:14:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 129 11:14:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 130 11:14:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='+ '))) 131 11:14:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 952= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=952 and XTDM00='+ '))) 132 11:14:14 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 133 11:14:14 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 134 11:14:14 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 135 11:14:14 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 136 11:14:14 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','YS_JKXXDZ','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE') 137 11:14:14 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','YS_JKXXDZ','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE') 138 11:14:14 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 952 139 11:14:14 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 952 140 11:14:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 141 11:14:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 142 11:14:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 143 11:14:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 144 11:14:14 SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=952 145 11:14:14 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=952 146 11:14:14 SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='5' 147 11:14:14 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='5' 148 11:14:22 SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00' 149 11:14:22 SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00' 150 11:14:22 SQL Prepare: ORACLE - Select * from xt_yzmblb where symbys=952 and mbgs00='0' 151 11:14:22 SQL Execute: ORACLE - Select * from xt_yzmblb where symbys=952 and mbgs00='0' 152 11:14:22 SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 153 11:14:22 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 154 11:14:22 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=952 and mbgs00='0') order by mbmc00 155 11:14:22 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=952 and mbgs00='0') order by mbmc00 156 11:14:22 SQL Prepare: ORACLE - Update XT_ZLMBMX a set ZLXMJC=(select b.ZLXMJC from bm_zlzd00 b where a.zlxmid=b.zlxmid) where exists (select 1 from bm_zlzd00 c where a.zlxmid=c.zlxmid) and a.zlxmid <> '0' 157 11:14:22 SQL Execute: ORACLE - Update XT_ZLMBMX a set ZLXMJC=(select b.ZLXMJC from bm_zlzd00 b where a.zlxmid=b.zlxmid) where exists (select 1 from bm_zlzd00 c where a.zlxmid=c.zlxmid) and a.zlxmid <> '0' 158 11:14:22 SQL Data In: ORACLE - Rows affected = 172 159 11:14:22 SQL Prepare: ORACLE - commit 160 11:14:22 SQL Execute: ORACLE - commit 161 11:14:22 SQL Data In: ORACLE - Rows affected = 0 162 11:14:23 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=952 and mbgs00='0') order by mbmc00 163 11:14:23 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=952 and mbgs00='0') order by mbmc00 164 11:14:23 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('入院病人') wbsm00,sf_yj_Getpysm('入院病人') pysm00 from dual where rownum=1 165 11:14:23 SQL Execute: ORACLE - Select sf_yj_GetWbsm('入院病人') wbsm00,sf_yj_Getpysm('入院病人') pysm00 from dual where rownum=1 166 11:14:23 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 167 11:14:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 168 11:14:23 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 169 11:14:23 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 170 11:14:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 171 11:14:23 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 172 11:14:23 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='1' order by zbbh00,znxh00 173 11:14:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 174 11:14:23 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 175 11:15:23 SQL Prepare: ORACLE - select 2*30*1/30 from dual where rownum=1 176 11:15:23 SQL Execute: ORACLE - select 2*30*1/30 from dual where rownum=1 177 11:15:24 SQL Prepare: ORACLE - select 2*30*1/30 from dual where rownum=1 178 11:15:24 SQL Execute: ORACLE - select 2*30*1/30 from dual where rownum=1 179 11:15:55 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 180 11:15:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 181 11:15:55 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 182 11:15:55 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 183 11:15:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 184 11:15:55 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 185 11:15:55 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='1' order by zbbh00,znxh00 186 11:15:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 187 11:15:55 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 188 11:16:07 SQL Prepare: ORACLE - select 2*30*1/30 from dual where rownum=1 189 11:16:07 SQL Execute: ORACLE - select 2*30*1/30 from dual where rownum=1 190 11:16:31 SQL Prepare: ORACLE - select 1*200*1/100 from dual where rownum=1 191 11:16:31 SQL Execute: ORACLE - select 1*200*1/100 from dual where rownum=1 192 11:16:35 SQL Prepare: ORACLE - select 1*100*1/100 from dual where rownum=1 193 11:16:35 SQL Execute: ORACLE - select 1*100*1/100 from dual where rownum=1 194 11:16:39 SQL Prepare: ORACLE - select 3*20*1/30 from dual where rownum=1 195 11:16:39 SQL Execute: ORACLE - select 3*20*1/30 from dual where rownum=1 196 11:16:48 SQL Prepare: ORACLE - select 1*0.3*1/0.1 from dual where rownum=1 197 11:16:48 SQL Execute: ORACLE - select 1*0.3*1/0.1 from dual where rownum=1 198 11:16:52 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 199 11:16:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 200 11:16:52 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 201 11:16:52 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 202 11:16:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 203 11:16:52 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 204 11:16:52 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='1' order by zbbh00,znxh00 205 11:16:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 206 11:16:52 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 207 11:17:02 SQL Prepare: ORACLE - select 3*20*1/30 from dual where rownum=1 208 11:17:02 SQL Execute: ORACLE - select 3*20*1/30 from dual where rownum=1 209 11:17:04 SQL Prepare: ORACLE - update xt_yzmb00 set MBMC00 ='入院病人',PYSM00 ='rybr',WBSM00 ='tbuw',YXBZ00 ='1',BZ0000 ='' Where MBID00 = 2362 210 11:17:04 SQL Execute: ORACLE - update xt_yzmb00 set MBMC00 ='入院病人',PYSM00 ='rybr',WBSM00 ='tbuw',YXBZ00 ='1',BZ0000 ='' Where MBID00 = 2362 211 11:17:04 SQL Data In: ORACLE - Rows affected = 1 212 11:17:04 SQL Prepare: ORACLE - update xt_ypmbmx set MXID00 = :1, MBID00 = :2, YPNM00 = :3, YFID00 = :4, PCID00 = :5, JL0000 = :6, YPZSL0 = :7, ZLDW00 = :8, YYSJ00 = :9, YYSJDW = :10, ZB0000 = :11, YYZF00 = :12, ZNXH00 = :13, ZBBH00 = :14 where MXID00 = :15 213 11:17:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 441.000000 214 11:17:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2362.000000 215 11:17:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3669.000000 216 11:17:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 001 217 11:17:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 218 11:17:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 219 11:17:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 220 11:17:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 片 221 11:17:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 222 11:17:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 天 223 11:17:04 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 224 11:17:04 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 225 11:17:04 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 226 11:17:04 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 227 11:17:04 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 441.000000 228 11:17:04 SQL Execute: ORACLE - update xt_ypmbmx set MXID00 = ?, MBID00 = ?, YPNM00 = ?, YFID00 = ?, PCID00 = ?, JL0000 = ?, YPZSL0 = ?, ZLDW00 = ?, YYSJ00 = ?, YYSJDW = ?, ZB0000 = ?, YYZF00 = ?, ZNXH00 = ?, ZBBH00 = ? where MXID00 = ? 229 11:17:04 SQL Error: ORACLE - ORA-00001: 违反唯一约束条件 (SD_HOSPITAL.XT_YPMBMX_YPNM00_UQ) 230 11:17:04 SQL Prepare: ORACLE - ROLLBACK WORK 231 11:17:04 SQL Execute: ORACLE - ROLLBACK WORK