1 15:52:20 Log started for: 住院医生工作站系统 2 15:52:20 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.98','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101111','15:52:20','scott@9999:32948CA42A15B172CB7BF80BC2C8637C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 15:52:20 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.98','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101111','15:52:20','scott@9999:32948CA42A15B172CB7BF80BC2C8637C' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 15:52:20 SQL Data In: ORACLE - Rows affected = 1 5 15:52:20 SQL Prepare: ORACLE - Commit 6 15:52:20 SQL Execute: ORACLE - Commit 7 15:52:20 SQL Data In: ORACLE - Rows affected = 0 8 15:52:20 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 15:52:20 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 15:52:20 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 15:52:20 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 15:52:20 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 13 15:52:20 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 14 15:52:20 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.98','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101111','15:52:20','sd_hospital@9999:48D0AF49135109986E68CE8BB64B41A3' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 15 15:52:20 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.98','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101111','15:52:20','sd_hospital@9999:48D0AF49135109986E68CE8BB64B41A3' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 16 15:52:20 SQL Data In: ORACLE - Rows affected = 1 17 15:52:20 SQL Prepare: ORACLE - Commit 18 15:52:20 SQL Execute: ORACLE - Commit 19 15:52:20 SQL Data In: ORACLE - Rows affected = 0 20 15:52:20 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 21 15:52:20 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 22 15:52:20 SQL Data In: ORACLE - Rows affected = 66 23 15:52:20 SQL Prepare: ORACLE - Commit 24 15:52:20 SQL Execute: ORACLE - Commit 25 15:52:20 SQL Data In: ORACLE - Rows affected = 0 26 15:52:20 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 27 15:52:20 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 28 15:52:20 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 29 15:52:20 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 30 15:52:20 SQL Prepare: ORACLE - Select SYSDATE from Dual 31 15:52:20 SQL Execute: ORACLE - Select SYSDATE from Dual 32 15:52:20 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 33 15:52:20 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 34 15:52:20 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 35 15:52:20 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 36 15:52:20 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 15:52:20 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 15:52:20 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 39 15:52:20 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 40 15:52:20 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 41 15:52:20 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 42 15:52:24 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'Z' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 43 15:52:24 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'Z' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 44 15:52:24 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=369 45 15:52:24 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=369 46 15:52:24 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 15:52:24 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 15:52:24 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 15:52:24 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 15:52:24 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 15:52:24 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 15:52:24 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 15:52:24 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 15:52:24 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')) 55 15:52:24 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')) 56 15:52:24 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1896867,369,'wlzx-2','Z',nvl('244436',' '),'192.168.14.98#135:34127@ZY_YS.exe+住院医生工作站系统',22) 57 15:52:24 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1896867,369,'wlzx-2','Z',nvl('244436',' '),'192.168.14.98#135:34127@ZY_YS.exe+住院医生工作站系统',22) 58 15:52:24 SQL Data In: ORACLE - Rows affected = 1 59 15:52:24 SQL Prepare: ORACLE - Commit 60 15:52:24 SQL Execute: ORACLE - Commit 61 15:52:24 SQL Data In: ORACLE - Rows affected = 0 62 15:52:24 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 22 63 15:52:24 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 22 64 15:52:24 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 65 15:52:24 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 66 15:52:24 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.98' 67 15:52:24 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.98' 68 15:52:24 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 69 15:52:24 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 70 15:52:24 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 22 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 71 15:52:24 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 22 and FLAG00 like '%' order by decode(CKBH00,21 --MRCKBH等于BM_CKBM00.CKBH00,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 72 15:52:24 SQL Data In: ORACLE - Rows affected = 0 73 15:52:24 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='369' and name00='SYSTEMSKIN' 74 15:52:24 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='369' and name00='SYSTEMSKIN' 75 15:52:24 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20101111' 76 15:52:24 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20101111' 77 15:52:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 15:52:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 79 15:52:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 15:52:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 81 15:52:24 SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 82 15:52:24 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 83 15:52:24 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 84 15:52:24 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 85 15:52:24 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 86 15:52:24 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 87 15:52:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='Z' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 88 15:52:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='Z' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 89 15:52:24 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 90 15:52:24 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 91 15:52:24 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 ((369= 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=369)))) 92 15:52:24 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 ((369= 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=369)))) 93 15:52:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 94 15:52:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 15:52:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 369= 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=369)))) 96 15:52:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 369= 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=369)))) 97 15:52:24 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 98 15:52:24 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 99 15:52:24 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 100 15:52:24 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 101 15:52:24 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB') 102 15:52:24 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB') 103 15:52:24 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 369 104 15:52:24 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 369 105 15:52:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 106 15:52:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 107 15:52:24 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 108 15:52:24 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 109 15:52:24 SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=369 110 15:52:24 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=369 111 15:52:24 SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='2' 112 15:52:24 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='2' 113 15:52:27 SQL Prepare: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=:1 or DQBQ00=:2) and ( 1=1 )ORDER BY RYCWH0 114 15:52:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 115 15:52:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 116 15:52:27 SQL Execute: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=? or DQBQ00=?) and ( 1=1 )ORDER BY RYCWH0 117 15:53:05 SQL Prepare: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=:1 or DQBQ00=:2) and ( 1=1 )ORDER BY RYCWH0 118 15:53:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 119 15:53:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 120 15:53:05 SQL Execute: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=? or DQBQ00=?) and ( 1=1 )ORDER BY RYCWH0 121 15:54:31 SQL Prepare: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=:1 or DQBQ00=:2) and ( 1=1 )ORDER BY RYCWH0 122 15:54:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 123 15:54:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 124 15:54:31 SQL Execute: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=? or DQBQ00=?) and ( 1=1 )ORDER BY RYCWH0 125 15:54:55 SQL Prepare: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=:1 or DQBQ00=:2) and ( 1=1 )ORDER BY RYCWH0 126 15:54:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 127 15:54:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 128 15:54:55 SQL Execute: ORACLE - SELECT ZYID00,MRN000,ZYH000,XM0000,XB0000,CJRQ00,CJSJ00,RYCWH0,BRZT00,RYRQ00,SXYS00,ZZYS00,ZRYS00,CYDJRQ FROM VW_ZS_BLLB00 A where (DQKS00=? or DQBQ00=?) and ( 1=1 )ORDER BY RYCWH0 129 15:55:12 SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=369 and mbgs00='0' and mblbbh='00' 130 15:55:12 SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=369 and mbgs00='0' and mblbbh='00' 131 15:55:12 SQL Prepare: ORACLE - Select * from xt_yzmblb where symbys=369 and mbgs00='0' 132 15:55:12 SQL Execute: ORACLE - Select * from xt_yzmblb where symbys=369 and mbgs00='0' 133 15:55:12 SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 134 15:55:12 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 135 15:55:12 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=369 and mbgs00='0') order by mbmc00 136 15:55:12 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=369 and mbgs00='0') order by mbmc00 137 15:55:12 SQL Prepare: ORACLE - Update XT_ZLMBMX a set ZLXMJC=(select b.ZLXMJC from bm_zlzd00 b where a.zlxmid=b.zlxmid) where exists (select 1 from bm_zlzd00 c where a.zlxmid=c.zlxmid) and a.zlxmid <> '0' 138 15:55:12 SQL Execute: ORACLE - Update XT_ZLMBMX a set ZLXMJC=(select b.ZLXMJC from bm_zlzd00 b where a.zlxmid=b.zlxmid) where exists (select 1 from bm_zlzd00 c where a.zlxmid=c.zlxmid) and a.zlxmid <> '0' 139 15:55:12 SQL Data In: ORACLE - Rows affected = 62 140 15:55:12 SQL Prepare: ORACLE - commit 141 15:55:12 SQL Execute: ORACLE - commit 142 15:55:12 SQL Data In: ORACLE - Rows affected = 0 143 15:55:15 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=369 and mbgs00='0') order by mbmc00 144 15:55:15 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=369 and mbgs00='0') order by mbmc00 145 15:55:16 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=369 and mbgs00='0') order by mbmc00 146 15:55:16 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=369 and mbgs00='0') order by mbmc00 147 15:55:22 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=369 and mbgs00='0') order by mbmc00 148 15:55:22 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000'and symbys=369 and mbgs00='0') order by mbmc00 149 15:55:23 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000000'and symbys=369 and mbgs00='0') order by mbmc00 150 15:55:23 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00000000'and symbys=369 and mbgs00='0') order by mbmc00 151 15:55:23 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('模板') wbsm00,sf_yj_Getpysm('模板') pysm00 from dual where rownum=1 152 15:55:23 SQL Execute: ORACLE - Select sf_yj_GetWbsm('模板') wbsm00,sf_yj_Getpysm('模板') pysm00 from dual where rownum=1 153 15:55:23 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 154 15:55:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 155 15:55:23 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=? and yplb00='0' order by zbbh00,znxh00 156 15:55:23 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 157 15:55:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 158 15:55:23 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 159 15:55:23 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='1' order by zbbh00,znxh00 160 15:55:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 161 15:55:23 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 162 15:55:25 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 163 15:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 164 15:55:25 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=? and yplb00='0' order by zbbh00,znxh00 165 15:55:25 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 166 15:55:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 167 15:55:25 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 168 15:55:27 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('模板') wbsm00,sf_yj_Getpysm('模板') pysm00 from dual where rownum=1 169 15:55:27 SQL Execute: ORACLE - Select sf_yj_GetWbsm('模板') wbsm00,sf_yj_Getpysm('模板') pysm00 from dual where rownum=1 170 15:55:27 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 171 15:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 172 15:55:27 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=Trim(f.yfid00(+)) and mbid00=? and yplb00='0' order by zbbh00,znxh00 173 15:55:27 SQL Prepare: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=:1 order by xsxh00 174 15:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 175 15:55:27 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000 from xt_zlmbmx x where mbid00=? order by xsxh00 176 15:55:27 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='1' order by zbbh00,znxh00 177 15:55:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1281.000000 178 15:55:27 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 179 15:55:30 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 180 15:55:30 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 181 15:55:30 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1 or zlxmbh Like :2) Order By zlxmbh,pysm00) where Rownum<=3000 182 15:55:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 183 15:55:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 184 15:55:30 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ? or zlxmbh Like ?) Order By zlxmbh,pysm00) where Rownum<=3000 185 15:55:31 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 186 15:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %v% 187 15:55:31 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 188 15:55:31 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 189 15:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %vv% 190 15:55:31 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 191 15:59:29 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1 or zlxmbh Like :2) Order By zlxmbh,pysm00) where Rownum<=3000 192 15:59:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 193 15:59:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 194 15:59:29 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ? or zlxmbh Like ?) Order By zlxmbh,pysm00) where Rownum<=3000 195 15:59:30 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 196 15:59:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %d% 197 15:59:30 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 198 15:59:30 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 199 15:59:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %dd% 200 15:59:30 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 201 15:59:30 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 202 15:59:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %ddd% 203 15:59:30 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 204 15:59:31 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 205 15:59:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %dddd% 206 15:59:31 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 207 15:59:32 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 208 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %ddd% 209 15:59:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 210 15:59:32 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 211 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %dd% 212 15:59:32 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 213 15:59:33 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 214 15:59:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %d% 215 15:59:33 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 216 15:59:33 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1 or zlxmbh Like :2) Order By zlxmbh,pysm00) where Rownum<=3000 217 15:59:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 218 15:59:33 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 219 15:59:33 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ? or zlxmbh Like ?) Order By zlxmbh,pysm00) where Rownum<=3000 220 15:59:34 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 221 15:59:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %x% 222 15:59:34 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 223 15:59:34 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 224 15:59:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %xx% 225 15:59:34 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 226 15:59:35 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 227 15:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %xxb% 228 15:59:35 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 229 15:59:35 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 230 15:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %xxbd% 231 15:59:35 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 232 15:59:35 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 233 15:59:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = %xxbdx% 234 15:59:35 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 235 15:59:36 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 236 15:59:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = %xxbdxj% 237 15:59:36 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 238 15:59:40 SQL Prepare: ORACLE - Select * from (select pcmc00,pcid00,pysm00,wbsm00,zqdw00,zqcs00,zqcd00 from vw_bm_pc0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 239 15:59:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %q% 240 15:59:40 SQL Execute: ORACLE - Select * from (select pcmc00,pcid00,pysm00,wbsm00,zqdw00,zqcs00,zqcd00 from vw_bm_pc0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 241 15:59:40 SQL Prepare: ORACLE - Select * from (select pcmc00,pcid00,pysm00,wbsm00,zqdw00,zqcs00,zqcd00 from vw_bm_pc0000 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 242 15:59:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %qd% 243 15:59:40 SQL Execute: ORACLE - Select * from (select pcmc00,pcid00,pysm00,wbsm00,zqdw00,zqcs00,zqcd00 from vw_bm_pc0000 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 244 15:59:45 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1 or zlxmbh Like :2) Order By zlxmbh,pysm00) where Rownum<=3000 245 15:59:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 246 15:59:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 247 15:59:45 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ? or zlxmbh Like ?) Order By zlxmbh,pysm00) where Rownum<=3000 248 15:59:46 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 249 15:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %x% 250 15:59:46 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 251 15:59:46 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 252 15:59:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %xx% 253 15:59:46 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 254 15:59:47 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 255 15:59:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %xxb% 256 15:59:47 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 257 15:59:47 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 258 15:59:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %xxbd% 259 15:59:47 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000 260 15:59:47 SQL Prepare: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like :1) Order By pysm00) where Rownum<=3000 261 15:59:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = %xxbdx% 262 15:59:47 SQL Execute: ORACLE - Select * from (select zlxmjc,zlxmid,zlxmbh,pysm00,wbsm00,dw0000,sfje00 from vw_zs_zlzd00 where (pysm00 Like ?) Order By pysm00) where Rownum<=3000