1 11:06:06 Log started for: 药房管理系统 2 11:06:06 SQL Data In: ORACLE - Rows affected = 1 3 11:06:06 SQL Prepare: ORACLE - Commit 4 11:06:06 SQL Execute: ORACLE - Commit 5 11:06:06 SQL Data In: ORACLE - Rows affected = 0 6 11:06:06 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 11:06:06 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 11:06:06 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 11:06:06 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 11:06:06 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3353' and CZBZ00 in ('1') 11 11:06:06 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3353' and CZBZ00 in ('1') 12 11:06:06 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.59','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20100401','11:06:06','sd_Hospital@3353:2A3C31B3887970C7F64DAEC1A66FE0D2' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 11:06:06 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.59','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20100401','11:06:06','sd_Hospital@3353:2A3C31B3887970C7F64DAEC1A66FE0D2' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 11:06:06 SQL Data In: ORACLE - Rows affected = 1 15 11:06:06 SQL Prepare: ORACLE - Commit 16 11:06:06 SQL Execute: ORACLE - Commit 17 11:06:06 SQL Data In: ORACLE - Rows affected = 0 18 11:06:06 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 19 11:06:06 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 20 11:06:06 SQL Data In: ORACLE - Rows affected = 0 21 11:06:06 SQL Prepare: ORACLE - Commit 22 11:06:06 SQL Execute: ORACLE - Commit 23 11:06:06 SQL Data In: ORACLE - Rows affected = 0 24 11:06:06 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 25 11:06:06 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 26 11:06:06 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3353' and CZBZ00 in ('1') 27 11:06:06 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3353' and CZBZ00 in ('1') 28 11:06:06 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 11:06:06 SQL Execute: ORACLE - Select SYSDATE from Dual 30 11:06:06 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 11:06:06 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 11:06:06 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 33 11:06:06 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 34 11:06:06 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 35 11:06:06 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 11:06:06 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 37 11:06:06 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 38 11:06:06 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3353')) order by BH0000 39 11:06:06 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3353')) order by BH0000 40 11:06:09 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '3353'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3353')) 41 11:06:09 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '3353'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3353')) 42 11:06:09 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=886 43 11:06:09 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=886 44 11:06:09 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 45 11:06:09 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 11:06:09 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 47 11:06:09 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 11:06:09 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 49 11:06:09 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 50 11:06:09 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 51 11:06:09 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 11:06:09 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')) 53 11:06:09 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')) 54 11:06:09 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2104301,886,'药库仓库','2',nvl('1860978',' '),'192.168.9.59#642:29754@appYP_YF.exe+药房管理系统',45) 55 11:06:09 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2104301,886,'药库仓库','2',nvl('1860978',' '),'192.168.9.59#642:29754@appYP_YF.exe+药房管理系统',45) 56 11:06:09 SQL Data In: ORACLE - Rows affected = 1 57 11:06:09 SQL Prepare: ORACLE - Commit 58 11:06:09 SQL Execute: ORACLE - Commit 59 11:06:09 SQL Data In: ORACLE - Rows affected = 0 60 11:06:09 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 61 11:06:09 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 62 11:06:09 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 63 11:06:09 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 64 11:06:09 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.59' 65 11:06:09 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.59' 66 11:06:09 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 67 11:06:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 68 11:06:09 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 69 11:06:09 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 70 11:06:09 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='886' and name00='SYSTEMSKIN' 71 11:06:09 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='886' and name00='SYSTEMSKIN' 72 11:06:09 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20100401' 73 11:06:09 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20100401' 74 11:06:09 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 75 11:06:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 76 11:06:09 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 77 11:06:09 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 78 11:06:09 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 79 11:06:09 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 80 11:06:09 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 81 11:06:09 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 82 11:06:09 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 83 11:06:09 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 84 11:06:09 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 85 11:06:09 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 86 11:06:09 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 87 11:06:09 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 88 11:06:09 SQL Prepare: ORACLE - select * from XT_XTCS00 89 11:06:09 SQL Execute: ORACLE - select * from XT_XTCS00 90 11:06:16 SQL Prepare: ORACLE - select * from BM_YPLB00 91 11:06:16 SQL Execute: ORACLE - select * from BM_YPLB00 92 11:06:16 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=886 93 11:06:16 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=886 94 11:06:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='2' and (( 886= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=886)))) 95 11:06:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='2' and (( 886= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=886)))) 96 11:06:16 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 97 11:06:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 98 11:06:16 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 ((886= 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=886)))) 99 11:06:16 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 ((886= 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=886)))) 100 11:06:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 101 11:06:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 102 11:06:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 886= 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=886)))) 103 11:06:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 886= 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=886)))) 104 11:06:16 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 105 11:06:16 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 106 11:06:17 SQL Prepare: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 107 11:06:17 SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 108 11:06:17 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 109 11:06:17 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 110 11:06:17 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 111 11:06:17 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 112 11:06:20 SQL Prepare: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 113 11:06:20 SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 114 11:06:20 SQL Prepare: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 115 11:06:20 SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 116 11:06:24 SQL Prepare: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=45 AND BQBMBH=59 117 11:06:24 SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=45 AND BQBMBH=59 118 11:06:24 SQL Data In: ORACLE - Rows affected = 1 119 11:06:24 SQL Prepare: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1' WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 120 11:06:24 SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1' WHERE YFBMBH=45 AND BQBMBH=59 AND QLZT00 IN('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 121 11:06:24 SQL Data In: ORACLE - Rows affected = 446 122 11:06:24 SQL Prepare: ORACLE - COMMIT 123 11:06:24 SQL Execute: ORACLE - COMMIT 124 11:06:24 SQL Data In: ORACLE - Rows affected = 0 125 11:06:25 SQL Prepare: ORACLE - SELECT Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,SUM(Y.YPZSL0) AS YPZSL0, Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.DXSYBZ,X.GZDJ00,0 JCSL00,Y.ZHL000, Y.HZBZ00 FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X WHERE Y.BQBMBH=:1 AND Y.YFBMBH=:2 AND Y.CLBZ00 LIKE :3 AND Y.QLZT00 IN ('0','1') AND Y.HZBZ00=:4 AND Y.FYBZ00='1' AND Y.YPNM00=D.YPNM00 AND Y.YPNM00=X.YPNM00 AND Y.YFBMBH=X.YFBMBH AND CXBZ00='Z' GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00, Y.YPNM00,Y.YPMC00,Y.YPGG00, Y.LSDJ00,Y.QLDW00,Y.BQBMBH, Y.YFBMBH,Y.ZHL000,Y.HZBZ00 126 11:06:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 127 11:06:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 128 11:06:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 129 11:06:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 130 11:06:25 SQL Execute: ORACLE - SELECT Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,SUM(Y.YPZSL0) AS YPZSL0, Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.DXSYBZ,X.GZDJ00,0 JCSL00,Y.ZHL000, Y.HZBZ00 FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X WHERE Y.BQBMBH=? AND Y.YFBMBH=? AND Y.CLBZ00 LIKE ? AND Y.QLZT00 IN ('0','1') AND Y.HZBZ00=? AND Y.FYBZ00='1' AND Y.YPNM00=D.YPNM00 AND Y.YPNM00=X.YPNM00 AND Y.YFBMBH=X.YFBMBH AND CXBZ00='Z' GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00, Y.YPNM00,Y.YPMC00,Y.YPGG00, Y.LSDJ00,Y.QLDW00,Y.BQBMBH, Y.YFBMBH,Y.ZHL000,Y.HZBZ00 131 11:06:25 SQL Prepare: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000 FROM YF_YZYPSQ WHERE YPNM00=:1 AND BQBMBH=:2 AND YFBMBH=:3 AND QLZT00 IN ('0','1') AND HZBZ00=:4 AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 132 11:06:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 532.000000 133 11:06:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 134 11:06:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 135 11:06:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 136 11:06:25 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000 FROM YF_YZYPSQ WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 137 11:06:26 SQL Prepare: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000 FROM YF_YZYPSQ WHERE YPNM00=:1 AND BQBMBH=:2 AND YFBMBH=:3 AND QLZT00 IN ('0','1') AND HZBZ00=:4 AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 138 11:06:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6423.000000 139 11:06:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 140 11:06:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 141 11:06:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 142 11:06:26 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000 FROM YF_YZYPSQ WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 143 11:06:30 SQL Prepare: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2519' and CZBZ00<>'2' and BMBH00='59' 144 11:06:30 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2519' and CZBZ00<>'2' and BMBH00='59' 145 11:06:30 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 146 11:06:30 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 147 11:06:30 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2519' and CZBZ00 in ('1') 148 11:06:30 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2519' and CZBZ00 in ('1') 149 11:06:30 SQL Prepare: ORACLE - Commit 150 11:06:30 SQL Execute: ORACLE - Commit 151 11:06:30 SQL Data In: ORACLE - Rows affected = 0 152 11:06:30 SQL Prepare: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END; 153 11:06:30 SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 154 11:06:30 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 155 11:06:30 SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 156 11:06:30 SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 157 11:06:30 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 158 11:06:30 SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 159 11:06:30 SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 886.000000 160 11:06:30 SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 880.000000 161 11:06:30 SQL Data In: ORACLE - Param = 9, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 162 11:06:30 SQL Data In: ORACLE - Param = 10, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 163 11:06:30 SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END; 164 11:06:31 SQL Prepare: ORACLE - Rollback 165 11:06:31 SQL Execute: ORACLE - Rollback 166 11:06:31 SQL Data In: ORACLE - Rows affected = 0