1 14:26:07 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 2 14:26:07 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 3 14:26:08 SQL Prepare: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) ORDER BY RYCWH0 4 14:26:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 5 14:26:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 6 14:26:08 SQL Execute: ORACLE - SELECT A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 7 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=287051 8 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=287051 9 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=290991 10 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=290991 11 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=158283 12 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=158283 13 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=287051 14 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=287051 15 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=290991 16 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=290991 17 14:26:08 SQL Prepare: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=158283 18 14:26:08 SQL Execute: ORACLE - SELECT * FROM VW_ZS_WTJBR0 WHERE ZYID00=158283 19 14:26:08 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 20 14:26:08 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ') 21 14:26:13 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 22 14:26:13 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 23 14:26:13 SQL Error: ORACLE - ORA-00936: 缺失表达式 24 14:26:13 SQL Error: ORACLE - Unmapped SQL Error Code: 936 25 14:26:13 SQL Data In: ORACLE - Rows affected = 0 26 14:26:32 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 290991 27 14:26:32 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 290991 28 14:26:32 SQL Prepare: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 290991 and (YZZT00 in ('7','0','1','2','5','9','7','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 29 14:26:32 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 290991 and (YZZT00 in ('7','0','1','2','5','9','7','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 30 14:26:34 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 290991 31 14:26:34 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = 290991 32 14:26:34 SQL Prepare: ORACLE - select dyrqsj,dypc00 from vw_zs_yzdyjl where zyid00=290991 and Clbz00='0' and nvl(yexm00,' ')=' ' order by dyrqsj desc 33 14:26:34 SQL Execute: ORACLE - select dyrqsj,dypc00 from vw_zs_yzdyjl where zyid00=290991 and Clbz00='0' and nvl(yexm00,' ')=' ' order by dyrqsj desc 34 14:26:34 SQL Prepare: ORACLE - select jzhs00,dyys00,zzdyhs from vw_zs_yzdyjl where ZYID00 = 290991 and CLBZ00= '0' and nvl(yexm00,' ')=' ' and dypc00=(select max(dypc00) from vw_zs_yzdyjl where ZYID00 = 290991 and CLBZ00= '0' and nvl(yexm00,' ')=' ') 35 14:26:34 SQL Execute: ORACLE - select jzhs00,dyys00,zzdyhs from vw_zs_yzdyjl where ZYID00 = 290991 and CLBZ00= '0' and nvl(yexm00,' ')=' ' and dypc00=(select max(dypc00) from vw_zs_yzdyjl where ZYID00 = 290991 and CLBZ00= '0' and nvl(yexm00,' ')=' ') 36 14:26:34 SQL Prepare: ORACLE - select * from VW_ZS_YZDY01 where ZYID00 = 290991 and CLBZ00 = '0' and nvl(yexm00,' ')=' ' and DYPC00 =0 order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 37 14:26:34 SQL Execute: ORACLE - select * from VW_ZS_YZDY01 where ZYID00 = 290991 and CLBZ00 = '0' and nvl(yexm00,' ')=' ' and DYPC00 =0 order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 38 14:40:01 Log started for: Yjsystem 39 14:40:01 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:03','scott@9696:AD773BC90039B5EA46DB75629B15B708' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 40 14:40:01 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:03','scott@9696:AD773BC90039B5EA46DB75629B15B708' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 41 14:40:01 SQL Data In: ORACLE - Rows affected = 1 42 14:40:01 SQL Prepare: ORACLE - Commit 43 14:40:01 SQL Execute: ORACLE - Commit 44 14:40:01 SQL Data In: ORACLE - Rows affected = 0 45 14:40:01 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 46 14:40:01 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 47 14:40:01 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 48 14:40:01 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 49 14:40:01 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 50 14:40:01 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 51 14:40:01 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:03','sd_Hospital@9696:CC66E9414759B991F7E0F30CAD737B32' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 52 14:40:01 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:03','sd_Hospital@9696:CC66E9414759B991F7E0F30CAD737B32' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 53 14:40:01 SQL Data In: ORACLE - Rows affected = 1 54 14:40:01 SQL Prepare: ORACLE - Commit 55 14:40:01 SQL Execute: ORACLE - Commit 56 14:40:01 SQL Data In: ORACLE - Rows affected = 0 57 14:40:01 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 58 14:40:01 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 59 14:40:01 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 60 14:40:01 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 61 14:40:03 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) 62 14:40:03 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) 63 14:40:03 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:06','scott@9696:924F7DA4FCBF71803E633E7C5C8536BA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 64 14:40:03 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:06','scott@9696:924F7DA4FCBF71803E633E7C5C8536BA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 65 14:40:03 SQL Data In: ORACLE - Rows affected = 1 66 14:40:03 SQL Prepare: ORACLE - Commit 67 14:40:03 SQL Execute: ORACLE - Commit 68 14:40:03 SQL Data In: ORACLE - Rows affected = 0 69 14:40:03 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 70 14:40:03 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 71 14:40:03 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 72 14:40:03 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 73 14:40:03 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 74 14:40:03 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 75 14:40:03 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:06','sd_Hospital@9696:97A464FEA08205D975C014CC598BB844' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 76 14:40:03 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','7',trim(PROGRAM)||'+'||'医技管理系统',SID,serial# ,'20091103','14:40:06','sd_Hospital@9696:97A464FEA08205D975C014CC598BB844' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 77 14:40:03 SQL Data In: ORACLE - Rows affected = 1 78 14:40:03 SQL Prepare: ORACLE - Commit 79 14:40:03 SQL Execute: ORACLE - Commit 80 14:40:03 SQL Data In: ORACLE - Rows affected = 0 81 14:40:03 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 82 14:40:03 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='7' 83 14:40:03 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 84 14:40:03 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9696' and CZBZ00 in ('1') 85 14:40:03 SQL Prepare: ORACLE - Select SYSDATE from Dual 86 14:40:03 SQL Execute: ORACLE - Select SYSDATE from Dual 87 14:40:03 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 88 14:40:03 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 89 14:40:03 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 90 14:40:03 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='7' 91 14:40:03 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 92 14:40:03 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 93 14:40:03 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 94 14:40:03 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 95 14:40:03 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1','5',',','1') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9696')) order by BH0000 96 14:40:03 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('1','5',',','1') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='7' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9696')) order by BH0000 97 14:40:07 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9696'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9696')) 98 14:40:07 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9696'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '7' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9696')) 99 14:40:07 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=888 100 14:40:07 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=888 101 14:40:07 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 102 14:40:07 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 103 14:40:07 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 104 14:40:07 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 105 14:40:07 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 106 14:40:07 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 107 14:40:07 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 108 14:40:07 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 109 14:40:07 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')) 110 14:40:07 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')) 111 14:40:07 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1938793,888,'wlzx-2','7',nvl('548111',' '),'192.168.13.206#809:21373@YJsystem.exe+医技管理系统',76) 112 14:40:07 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1938793,888,'wlzx-2','7',nvl('548111',' '),'192.168.13.206#809:21373@YJsystem.exe+医技管理系统',76) 113 14:40:07 SQL Data In: ORACLE - Rows affected = 1 114 14:40:07 SQL Prepare: ORACLE - Commit 115 14:40:07 SQL Execute: ORACLE - Commit 116 14:40:07 SQL Data In: ORACLE - Rows affected = 0 117 14:40:07 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 76 118 14:40:07 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 76 119 14:40:07 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 120 14:40:07 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 121 14:40:07 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 122 14:40:07 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 123 14:40:07 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 124 14:40:07 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 125 14:40:07 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 76 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 126 14:40:07 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 76 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 127 14:40:07 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20091103' 128 14:40:07 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='7') and YXQ000>='20091103' 129 14:40:07 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 130 14:40:07 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 131 14:40:07 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 132 14:40:07 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 133 14:40:07 SQL Prepare: ORACLE - select sysdate from dual 134 14:40:07 SQL Execute: ORACLE - select sysdate from dual 135 14:40:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='7' and (( 888= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=888)))) 136 14:40:07 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='7' and (( 888= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=888)))) 137 14:40:07 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 ((888= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=888)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 138 14:40:07 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '7$%' and A.XTDM00='7' and trim(A.MKDM00)='7$'||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 ((888= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='7' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=888)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 139 14:40:07 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 ((888= 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=888)))) 140 14:40:07 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 ((888= 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=888)))) 141 14:40:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 142 14:40:07 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 143 14:40:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 888= 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=888)))) 144 14:40:07 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 888= 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=888)))) 145 14:40:07 SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 146 14:40:07 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 147 14:40:07 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY') and YGBH00 = 888 148 14:40:07 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet','YJ_TMSFDY') and YGBH00 = 888 149 14:40:07 SQL Prepare: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YJ_YXCXTS','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY') 150 14:40:07 SQL Execute: ORACLE - select NAME00,VALUE0,BZ0000 from xt_xtcs00 where NAME00 in ('YJ_XMYXTS','YJ_YZCFXZSL','YJ_JYDDYFS','YJ_SFBXGH','YJ_SFSRBZ','MZYS_YBBRYXGH','YJ_XSZXM','YJ_JYZXDFKDY','YJ_SYBLHCZ','YJ_YWCX_CXSQYZXXM','YJ_JSYMR','YJ_XMWHSFXSMBYY','YJ_KLBZH','YJ_XMCXZJTF','YJ_YJMRGHLB','YJ_SFXMTOZLZD_PLSCTS','YJ_ZDYDY_SYK','YJ_GHHZYHWKSFMRSYBR','YJ_SFXMSFZLCL','YJ_CFLR_ZYLYL','YJ_XMSQ_KSYS','YS_KDSCTXM','YJ_TMTSY','YJ_CFLRQYTS','YS_YSXMSQD','YJ_ZXDDKDYKS','YJ_YXCXTS','ZY_SFSYFPXMZMYHJM','YJ_ZDYDY_ZXD','YJ_RHXMLYKSZX','YJ_JSXMSFXZ','YJ_ZDYMBID','YJ_ZDDYJYDKS','YJ_XMZXDKHQX','YJ_XMWHGHTS','YJ_XMZXSLMRYC','YK_YF_LSJSFDLGL','YK_RCKTJDDYHS','YK_RCKTJDSFKZSRHS','YK_SFYTYMLT','BQ_YPMCLB','YJ_TXMQJZM','YJ_XMZJMRKSYS','YF_CFMXJE_CZFS','YF_CFMXJE_SRWS','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XSSYYXGHGXZ','BQ_TMDYJ','YJ_XMZJYSWSSKS','YJ_XSKDYGS','BQ_YJ_BQXMCXSQ','YJ_JSYCFYPYFSFYXWK','YJ_XMWHYYMBSQBMYS','YJ_TJDZDDFKLC','XT_BRBYKFB','YJ_WXGHKS','YJ_YJXMZJXSSSKS','YJ_MRDYGZXKS','YJ_GHSFKYZDGHYS','YJ_XMZXSFYXCHCX','YJ_ZDKSYXQXMZX','YJ_LSCFJZSFQY') 151 14:40:07 SQL Prepare: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 152 14:40:07 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 153 14:40:07 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=888 and name00='YJ_QSBRLB' 154 14:40:07 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=888 and name00='YJ_QSBRLB' 155 14:40:24 SQL Prepare: ORACLE - select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 from (select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=:1 and b.czrq00<=:2 and a.xmzt00 in ('2','3','4') and a.mzzybz='1' and a.yjksbh+0=:3 union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=:4 and b.czrq00<=:5 and a.xmzt00 in ('2','3','4') and a.mzzybz<>'1' and a.yjksbh+0=:6 ) y group by zlxmid ) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid 156 14:40:43 SQL Data In: ORACLE - Rows affected = 0 157 14:40:43 SQL Prepare: ORACLE - select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=:1 and b.czrq00<=:2 and a.xmzt00 in ('2','3','4') and a.mzzybz='1' and a.yjksbh+0=:3 union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=:4 and b.czrq00<=:5 and a.xmzt00 in ('2','3','4') and a.mzzybz<>'1' and a.yjksbh+0=:6 ) y group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid 158 14:40:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091001 159 14:40:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091031 160 14:40:43 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 76.000000 161 14:40:43 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091001 162 14:40:43 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20091031 163 14:40:43 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 76.000000 164 14:40:43 SQL Execute: ORACLE - select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') and a.mzzybz='1' and a.yjksbh+0=? union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') and a.mzzybz<>'1' and a.yjksbh+0=? ) y group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid 165 15:53:40 Log started for: 住院医生工作站系统 166 15:53:59 Log started for: 库存物资管理子系统 167 15:53:59 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:01','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 168 15:53:59 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:01','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 169 15:53:59 SQL Data In: ORACLE - Rows affected = 1 170 15:53:59 SQL Prepare: ORACLE - Commit 171 15:53:59 SQL Execute: ORACLE - Commit 172 15:53:59 SQL Data In: ORACLE - Rows affected = 0 173 15:53:59 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 174 15:53:59 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 175 15:53:59 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 176 15:53:59 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 177 15:53:59 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 178 15:53:59 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 179 15:53:59 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:01','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 180 15:53:59 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:01','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 181 15:53:59 SQL Data In: ORACLE - Rows affected = 1 182 15:53:59 SQL Prepare: ORACLE - Commit 183 15:53:59 SQL Execute: ORACLE - Commit 184 15:53:59 SQL Data In: ORACLE - Rows affected = 0 185 15:53:59 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 186 15:53:59 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 187 15:53:59 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 188 15:53:59 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 189 15:53:59 SQL Prepare: ORACLE - Select SYSDATE from Dual 190 15:53:59 SQL Execute: ORACLE - Select SYSDATE from Dual 191 15:53:59 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 192 15:53:59 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 193 15:53:59 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 194 15:53:59 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 195 15:53:59 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 196 15:53:59 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 197 15:53:59 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 198 15:53:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 199 15:53:59 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8','4','6','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 200 15:53:59 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8','4','6','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 201 15:54:00 Log started for: 住院医生工作站系统 202 15:54:13 Log started for: 库存物资管理子系统 203 15:54:13 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:15','scott@9027:8FDA3E4AF03C5F799A37CAE63A2568F4' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 204 15:54:13 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:15','scott@9027:8FDA3E4AF03C5F799A37CAE63A2568F4' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 205 15:54:13 SQL Data In: ORACLE - Rows affected = 1 206 15:54:13 SQL Prepare: ORACLE - Commit 207 15:54:13 SQL Execute: ORACLE - Commit 208 15:54:13 SQL Data In: ORACLE - Rows affected = 0 209 15:54:13 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 210 15:54:13 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 211 15:54:13 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 212 15:54:13 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 213 15:54:13 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9027' and CZBZ00 in ('1') 214 15:54:13 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9027' and CZBZ00 in ('1') 215 15:54:13 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:15','sd_Hospital@9027:9D0590C7DAA1F6C59A457B1AD5DE5CDD' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 216 15:54:13 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','K',trim(PROGRAM)||'+'||'库存物资管理子系统',SID,serial# ,'20091103','15:54:15','sd_Hospital@9027:9D0590C7DAA1F6C59A457B1AD5DE5CDD' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 217 15:54:13 SQL Data In: ORACLE - Rows affected = 1 218 15:54:13 SQL Prepare: ORACLE - Commit 219 15:54:13 SQL Execute: ORACLE - Commit 220 15:54:13 SQL Data In: ORACLE - Rows affected = 0 221 15:54:13 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 222 15:54:13 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='K' 223 15:54:13 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9027' and CZBZ00 in ('1') 224 15:54:13 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9027' and CZBZ00 in ('1') 225 15:54:13 SQL Prepare: ORACLE - Select SYSDATE from Dual 226 15:54:13 SQL Execute: ORACLE - Select SYSDATE from Dual 227 15:54:13 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 228 15:54:13 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 229 15:54:13 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 230 15:54:13 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='K' 231 15:54:13 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 232 15:54:13 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 233 15:54:13 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 234 15:54:13 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = 'SLE4442' 235 15:54:13 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8','4','6','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9027')) order by BH0000 236 15:54:13 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('c','9','1','5','2','a','8','4','6','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='K' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9027')) order by BH0000 237 15:54:13 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9027'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9027')) 238 15:54:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9027'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'K' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9027')) 239 15:54:13 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=896 240 15:54:13 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=896 241 15:54:13 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 242 15:54:13 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 243 15:54:13 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 244 15:54:13 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 245 15:54:13 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 246 15:54:13 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 247 15:54:13 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 248 15:54:13 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 249 15:54: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')) 250 15:54: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')) 251 15:54:13 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1938891,896,'wlzx-2','K',nvl('548411',' '),'192.168.13.206#609:4355@prjSB_KCWZ.exe+库存物资管理子系统',176) 252 15:54:13 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1938891,896,'wlzx-2','K',nvl('548411',' '),'192.168.13.206#609:4355@prjSB_KCWZ.exe+库存物资管理子系统',176) 253 15:54:13 SQL Data In: ORACLE - Rows affected = 1 254 15:54:13 SQL Prepare: ORACLE - Commit 255 15:54:13 SQL Execute: ORACLE - Commit 256 15:54:13 SQL Data In: ORACLE - Rows affected = 0 257 15:54:13 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 176 258 15:54:13 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 176 259 15:54:13 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 260 15:54:13 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 261 15:54:13 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 262 15:54:13 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 263 15:54:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 264 15:54:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 265 15:54:13 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 176 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 266 15:54:13 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 176 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 267 15:54:14 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20091103' 268 15:54:14 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='K') and YXQ000>='20091103' 269 15:54:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 270 15:54:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 271 15:54:14 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 272 15:54:14 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 273 15:54:14 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=176 274 15:54:14 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=176 275 15:54:14 SQL Prepare: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 276 15:54:14 SQL Execute: ORACLE - SELECT 1 EXIST FROM XT_YYXT00 WHERE XTDM00='K' AND BMXZ00 LIKE '%c%' 277 15:54:14 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 278 15:54:14 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_WZ_%' AND STATUS<>'VALID' 279 15:54:14 SQL Prepare: ORACLE - delete SD_SB.WZ_TEMP00 280 15:54:14 SQL Execute: ORACLE - delete SD_SB.WZ_TEMP00 281 15:54:14 SQL Data In: ORACLE - Rows affected = 1405 282 15:54:14 SQL Prepare: ORACLE - Commit 283 15:54:14 SQL Execute: ORACLE - Commit 284 15:54:14 SQL Data In: ORACLE - Rows affected = 0 285 15:54:14 SQL Prepare: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 286 15:54:14 SQL Execute: ORACLE - select * from XT_XTCS00 where name00 like 'WZ_%' 287 15:54:14 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=896 288 15:54:14 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=896 289 15:54:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 896= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=896)))) 290 15:54:14 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='K' and (( 896= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=896)))) 291 15:54:14 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||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 ((896= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=896)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 292 15:54:14 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'K$%' and A.XTDM00='K' and trim(A.MKDM00)='K$'||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 ((896= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='K' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=896)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 293 15:54: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 ((896= 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=896)))) 294 15:54: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 ((896= 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=896)))) 295 15:54:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 296 15:54:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 297 15:54:14 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 896= 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=896)))) 298 15:54:14 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 896= 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=896)))) 299 15:54:19 SQL Prepare: ORACLE - select PDID00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDBMBH=176 300 15:54:19 SQL Execute: ORACLE - select PDID00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDBMBH=176 301 15:54:19 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3901 302 15:54:19 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3901 303 15:54:19 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 304 15:54:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3901.000000 305 15:54:19 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 306 15:54:24 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3901 307 15:54:24 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3901 308 15:54:24 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3901 309 15:54:24 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3901 310 15:54:25 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 311 15:54:25 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 312 15:54:25 SQL Data In: ORACLE - Rows affected = 0 313 15:54:25 SQL Prepare: ORACLE - Rollback 314 15:54:25 SQL Execute: ORACLE - Rollback 315 15:54:25 SQL Data In: ORACLE - Rows affected = 0 316 15:54:25 SQL Prepare: ORACLE - ROLLBACK WORK 317 15:54:25 SQL Execute: ORACLE - ROLLBACK WORK 318 16:12:06 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3602 319 16:12:06 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3602 320 16:12:06 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 321 16:12:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3602.000000 322 16:12:06 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 323 16:12:08 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3602 324 16:12:08 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3602 325 16:12:08 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3602 326 16:12:08 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3602 327 16:12:08 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 328 16:12:08 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 329 16:12:08 SQL Data In: ORACLE - Rows affected = 0 330 16:12:08 SQL Prepare: ORACLE - Rollback 331 16:12:08 SQL Execute: ORACLE - Rollback 332 16:12:08 SQL Data In: ORACLE - Rows affected = 0 333 16:12:08 SQL Prepare: ORACLE - ROLLBACK WORK 334 16:12:08 SQL Execute: ORACLE - ROLLBACK WORK 335 16:12:12 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3502 336 16:12:12 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3502 337 16:12:12 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 338 16:12:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3502.000000 339 16:12:12 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 340 16:12:13 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3502 341 16:12:13 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3502 342 16:12:13 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3502 343 16:12:13 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3502 344 16:12:14 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 345 16:12:14 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 346 16:12:14 SQL Data In: ORACLE - Rows affected = 0 347 16:12:14 SQL Prepare: ORACLE - Rollback 348 16:12:14 SQL Execute: ORACLE - Rollback 349 16:12:14 SQL Data In: ORACLE - Rows affected = 0 350 16:12:14 SQL Prepare: ORACLE - ROLLBACK WORK 351 16:12:14 SQL Execute: ORACLE - ROLLBACK WORK 352 16:12:26 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 353 16:12:26 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 354 16:12:26 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 355 16:12:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3703.000000 356 16:12:26 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 357 16:14:16 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 358 16:14:16 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 359 16:14:16 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 360 16:14:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3703.000000 361 16:14:16 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 362 16:16:25 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3704 363 16:16:25 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3704 364 16:16:25 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 365 16:16:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3704.000000 366 16:16:25 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 367 16:16:27 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3502 368 16:16:27 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3502 369 16:16:27 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 370 16:16:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3502.000000 371 16:16:27 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 372 16:16:30 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3702 373 16:16:30 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3702 374 16:16:30 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 375 16:16:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3702.000000 376 16:16:30 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 377 16:16:32 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3602 378 16:16:32 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3602 379 16:16:32 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 380 16:16:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3602.000000 381 16:16:32 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 382 16:17:20 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3602 383 16:17:20 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3602 384 16:17:20 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3602 385 16:17:20 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3602 386 16:17:20 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 387 16:17:20 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 388 16:17:20 SQL Data In: ORACLE - Rows affected = 0 389 16:17:20 SQL Prepare: ORACLE - Rollback 390 16:17:20 SQL Execute: ORACLE - Rollback 391 16:17:20 SQL Data In: ORACLE - Rows affected = 0 392 16:17:20 SQL Prepare: ORACLE - ROLLBACK WORK 393 16:17:20 SQL Execute: ORACLE - ROLLBACK WORK 394 16:17:36 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 395 16:17:36 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 396 16:17:36 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 397 16:17:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3703.000000 398 16:17:36 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 399 16:18:57 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3703 400 16:18:57 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3703 401 16:18:57 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3703 402 16:18:57 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3703 403 16:18:57 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 404 16:18:57 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 405 16:18:57 SQL Data In: ORACLE - Rows affected = 0 406 16:18:57 SQL Prepare: ORACLE - Rollback 407 16:18:57 SQL Execute: ORACLE - Rollback 408 16:18:57 SQL Data In: ORACLE - Rows affected = 0 409 16:18:57 SQL Prepare: ORACLE - ROLLBACK WORK 410 16:18:57 SQL Execute: ORACLE - ROLLBACK WORK 411 16:19:30 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 412 16:19:30 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3703 413 16:19:30 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 414 16:19:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3703.000000 415 16:19:30 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 416 16:19:32 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3702 417 16:19:32 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3702 418 16:19:32 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 419 16:19:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3702.000000 420 16:19:32 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 421 16:19:33 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3704 422 16:19:33 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3704 423 16:19:33 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 424 16:19:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3704.000000 425 16:19:33 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 426 16:19:34 SQL Prepare: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3501 427 16:19:34 SQL Execute: ORACLE - select PDID00,WZSXMC,PDRQ00,PDDH00 from VW_WZ_PD0000 where PDBZ00='0' and PDID00=3501 428 16:19:34 SQL Prepare: ORACLE - select * from VW_WZ_PDMX00 where PDID00=:1 order by PDMXID 429 16:19:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3501.000000 430 16:19:34 SQL Execute: ORACLE - select * from VW_WZ_PDMX00 where PDID00=? order by PDMXID 431 16:19:39 SQL Prepare: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3501 432 16:19:39 SQL Execute: ORACLE - select sum(YKJE00) YKJE00 from WZ_PDMX00 where PDID00=3501 433 16:19:39 SQL Prepare: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3501 434 16:19:39 SQL Execute: ORACLE - update WZ_PD0000 set PDBZ00='1' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') ,QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0=896,YKJE00=0 ,BZ0000='' WHERE PDID00=3501 435 16:19:39 SQL Error: ORACLE - ORA-20003: 盘点表审核转成出入库单并修改库存发生意外错误!*返回信息:100ORA-01403: 未找到任何数据 ORA-06512: 在 "SD_HOSPITAL.TR_WZ_RCK000_PDBZ00", line 163 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_RCK000_PDBZ00' 执行过程中出错 436 16:19:39 SQL Error: ORACLE - Unmapped SQL Error Code: 20003 437 16:19:39 SQL Data In: ORACLE - Rows affected = 0 438 16:19:39 SQL Prepare: ORACLE - Rollback 439 16:19:39 SQL Execute: ORACLE - Rollback 440 16:19:39 SQL Data In: ORACLE - Rows affected = 0 441 16:19:39 SQL Prepare: ORACLE - ROLLBACK WORK 442 16:19:39 SQL Execute: ORACLE - ROLLBACK WORK