1 17:10:12 Log started for: 药库管理系统 2 17:10:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 17:10:12 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.127','3','appYP_YK.exe'||'+'||'药库管理系统','150','36726' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@4144:B70D739555539CD87E37D9C962AD78D4' from dual 4 17:10:12 SQL Data In: ORACLE - Rows affected = 1 5 17:10:12 SQL Execute: ORACLE - Commit 6 17:10:12 SQL Data In: ORACLE - Rows affected = 0 7 17:10:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 17:10:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='221218' 9 17:10:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='4144' and CZBZ00 in ('1') 10 17:10:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 17:10:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.11.127','3','appYP_YK.exe'||'+'||'药库管理系统','168','28862' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@4144:351F2EF62035D3185066A6638BDE3100' from dual 12 17:10:12 SQL Data In: ORACLE - Rows affected = 1 13 17:10:12 SQL Execute: ORACLE - Commit 14 17:10:12 SQL Data In: ORACLE - Rows affected = 0 15 17:10:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 16 17:10:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='4144' and CZBZ00 in ('1') 17 17:10:12 SQL Execute: ORACLE - Select SYSDATE from Dual 18 17:10:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 19 17:10:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0)=upper('sd_Hospital') and ROWNUM = 1 20 17:10:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 21 17:10:12 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 22 17:10: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') and KLDH00 = 'SLE4442' 23 17:10: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') and KLDH00 = 'YB-MMRK' 24 17:10: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') and KLDH00 = 'YB-SBK' 25 17:10:12 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4144')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('6') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4144')) order by b.PLXH00,a.BH0000 26 17:10:19 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '4144'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '3' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4144')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='4144') 27 17:10:19 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=614 28 17:10:19 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 17:10:19 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 17:10:19 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 17:10:19 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 32 17:10:19 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')) 33 17:10:19 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1936230,614,'MJYY-20150115NG','3',nvl('17829423',' '),'192.168.11.127#168:28862@appYP_YK.exe+药库管理系统',12) 34 17:10:19 SQL Data In: ORACLE - Rows affected = 1 35 17:10:19 SQL Execute: ORACLE - Commit 36 17:10:19 SQL Data In: ORACLE - Rows affected = 0 37 17:10:19 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 38 17:10:19 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221218' 39 17:10:19 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 40 17:10:19 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.11.127' 41 17:10:19 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 42 17:10:19 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 12 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 43 17:10:19 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221218') 44 17:10:19 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (nvl(a.YYID00,'0')='221218' or trim(nvl(a.YYID00,'0'))='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 ) 45 17:10:19 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='614' and name00='SYSTEMSKIN' 46 17:10:19 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 47 17:10:19 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20160718' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='3') 48 17:10:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 49 17:10:19 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 50 17:10:19 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 51 17:10:19 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 52 17:10:19 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 53 17:10:19 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID' 54 17:10:19 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 55 17:10:19 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 56 17:10:19 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 57 17:10:20 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=614 58 17:10:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 614= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=614 and XTDM00='3'))) 59 17:10:20 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||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 60 17:10:20 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 ((614= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=614 and XTDM00='0 '))) 61 17:10:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 62 17:10:20 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 614= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=614 and XTDM00='+ '))) 63 17:10:20 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 64 17:10:20 SQL Execute: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX WHERE YKBMBH=12 AND KCSL00 :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 74 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 75 17:10:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=1936230) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 76 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 77 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 78 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 79 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 80 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 81 17:10:35 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 82 17:10:35 SQL Data In: ORACLE - Param = 2, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 83 17:10:35 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 84 17:10:35 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 85 17:10:35 SQL Execute: ORACLE - BEGIN "SP_YK_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 86 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 87 17:10:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=1936230) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 88 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 89 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 90 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 91 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 92 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 93 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 94 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 95 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 96 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 97 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 98 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 99 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 100 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 101 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 102 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 103 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 104 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 105 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 106 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 107 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 108 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 109 17:10:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=1936230) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 110 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 111 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 112 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 113 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 114 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 115 17:10:35 SQL Data In: ORACLE - Param = 1, Name = P_SYSPROCESSID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 116 17:10:35 SQL Data In: ORACLE - Param = 2, Name = P_YKBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 117 17:10:35 SQL Data In: ORACLE - Param = 3, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 118 17:10:35 SQL Data In: ORACLE - Param = 4, Name = P_CKLXBH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 05 119 17:10:35 SQL Execute: ORACLE - BEGIN "SP_YK_YPCKLSSJSC" (P_SYSPROCESSID => :P_SYSPROCESSID,P_YKBMBH => :P_YKBMBH,P_YPQLDH => :P_YPQLDH,P_CKLXBH => :P_CKLXBH); END; 120 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 121 17:10:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=1936230) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 122 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 123 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 124 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 125 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 126 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 127 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 128 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 129 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 130 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 131 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 132 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 133 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 134 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 135 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 136 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 137 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 138 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 139 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 140 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 141 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 142 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 143 17:10:35 SQL Execute: ORACLE - select B.YPBM00,A.*,B.YPTYM0,(select NVL(sum(PCKCSL),0) from YK_YPQLMX_TEMP where YPQLPC=A.YPQLPC and YPQLDH=A.YPQLDH AND YPNM00=B.YPNM00 AND SYSPID=1936230) As XYKC00,B.PDXH00,0 ZXYFKC,0 XYFKC0,b.ypmlbz, (select round(D.SJKCSL/B.K2J000,3) from YF_YPKCXX D where A.YPNM00=D.YPNM00 and D.YFBMBH=C.CKQXBH) YFKC00 From YK_YPQLMX A,BM_YD0000 B,YK_YPQLD0 C where A.YPQLDH=? AND A.YPNM00=B.YPNM00 AND A.YPQLDH=C.YPQLDH ORDER BY A.YPQLPC 144 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 145 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 146 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 147 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 148 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 149 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 150 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 151 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 152 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 153 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 154 17:10:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 155 17:10:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 156 17:10:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 157 17:10:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 158 17:10:35 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 159 17:10:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 160 17:10:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 161 17:10:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 162 17:10:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 163 17:10:51 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 164 17:10:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 165 17:10:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 166 17:10:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 167 17:10:51 SQL Execute: ORACLE - update YK_YPQLMX set SFSL00 = ? where YPQLPC = ? and YPQLDH = ? 168 17:10:51 SQL Data In: ORACLE - Rows affected = 1 169 17:10:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 170 17:10:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 171 17:10:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 172 17:10:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 173 17:10:51 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 174 17:10:51 SQL Execute: ORACLE - commit 175 17:10:52 SQL Data In: ORACLE - Rows affected = 0 176 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 177 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168414.000000 178 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3432.000000 179 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 180 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 181 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 182 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168410.000000 183 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8998.000000 184 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 185 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 186 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 187 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168411.000000 188 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 271.000000 189 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 190 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 191 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 192 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168412.000000 193 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3340.000000 194 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 195 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 196 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 197 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168413.000000 198 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3410.000000 199 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 200 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 201 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 202 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168414.000000 203 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3432.000000 204 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 205 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 206 17:10:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 207 17:10:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 168414.000000 208 17:10:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3432.000000 209 17:10:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 210 17:10:52 SQL Execute: ORACLE - select t.* FROM YK_YPQLMX_TEMP T WHERE T.YPQLDH=? AND T.YPQLPC=? AND T.YPNM00=? AND T.SYSPID=? order by T.YPSXRQ,T.SCPH00,T.PCLYSL DESC 211 17:10:52 SQL Execute: ORACLE - Select FYBZ00 from BM_BMBM00 where BMBH00=12 212 17:10:52 SQL Data In: ORACLE - Param = 1, Name = P_YPQLDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 036777 213 17:10:52 SQL Data In: ORACLE - Param = 2, Name = P_SYSPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1936230.000000 214 17:10:52 SQL Data In: ORACLE - Param = 3, Name = P_QRRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 614.000000 215 17:10:52 SQL Execute: ORACLE - BEGIN "SP_YK_YPSLCKQR" (P_YPQLDH => :P_YPQLDH,P_SYSPID => :P_SYSPID,P_QRRBH0 => :P_QRRBH0); END; 216 17:10:52 SQL Error: ORACLE - ORA-20004: 出库确认时发生意外错误!*返回信息:调用过程: SP_YK_YPSLCKQR(036777,1936230,614) ; ORA-20005: 出库记账及修改库存时发生意外错误!*返回信息:ORA-20004: 数据没有找到！ORA-04091: 表 SD_YK.YK_YPCKMX 发生了变化, 触发器/函数不能读它 ORA-06512: 在 "SD_HOSPITAL.TR_BM_YD0000_UPDATE_XZ", line 66 ORA-04088: 触发器 'SD_HOSPITAL.TR_BM_YD0000_UPDATE_XZ' 执行过程中出错 ORA-06512: 在 "SD_HOSPITAL.TR_YK_YPCKMX_AFINT", line 316 ORA-04088: 触发器 'SD_HOSPITAL.TR_YK_YPCKMX_AFINT' 执行过程中出错 ORA-06512: 在 "SD_HOSPITAL 217 17:10:52 SQL Error: ORACLE - Unmapped SQL Error Code: 20004