1 09:20:32 Log started for: 住院收费管理系统 2 09:20:32 SQL Prepare: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3 09:20:32 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 4 09:20:32 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','5',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 09:20:32 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.9.252','5',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 6 09:20:32 SQL Prepare: ORACLE - Commit 7 09:20:32 SQL Execute: ORACLE - Commit 8 09:20:32 SQL Prepare: ORACLE - Select SYSDATE from Dual 9 09:20:32 SQL Execute: ORACLE - Select SYSDATE from Dual 10 09:20:32 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 11 09:20:32 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 12 09:20:32 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 13 09:20:32 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 14 09:20:32 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 15 09:20:32 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 09:20:32 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 17 09:20:32 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 18 09:20:32 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 19 09:20:32 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='5' 20 09:20:34 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('4') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 21 09:20:34 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('4') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 22 09:20:36 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 23 09:20:36 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 24 09:20:36 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 25 09:20:36 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00='1' 26 09:20:36 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 27 09:20:36 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 09:20:36 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 29 09:20:36 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 09:20:36 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 09:20:36 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 32 09:20:36 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 33 09:20:36 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 34 09:20:36 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1797134,476,'wlzx-2','5',nvl('3138179',' '),'',43) 35 09:20:36 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1797134,476,'wlzx-2','5',nvl('3138179',' '),'',43) 36 09:20:36 SQL Prepare: ORACLE - Commit 37 09:20:36 SQL Execute: ORACLE - Commit 38 09:20:36 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 39 09:20:36 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 40 09:20:36 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 41 09:20:36 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 42 09:20:36 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 43 09:20:36 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 44 09:20:36 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 45 09:20:36 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 46 09:20:36 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20090702' 47 09:20:36 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20090702' 48 09:20:36 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 49 09:20:36 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 50 09:20:37 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 51 09:20:37 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 52 09:20:37 SQL Prepare: ORACLE - select sysdate nowtime from dual 53 09:20:37 SQL Execute: ORACLE - select sysdate nowtime from dual 54 09:20:37 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 55 09:20:37 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 56 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJHSC0' 57 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJHSC0' 58 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_MRNZYH' 59 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_MRNZYH' 60 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_DYYBFP' 61 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_DYYBFP' 62 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00 ' 63 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00 ' 64 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHTYJE' 65 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHTYJE' 66 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHBJJE' 67 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZHBJJE' 68 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBJSTKD' 69 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBJSTKD' 70 09:20:37 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_SFYJS0_BZ0000' 71 09:20:37 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_SFYJS0_BZ0000' 72 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_WJZBNCY' 73 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_WJZBNCY' 74 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PRINTSCALE' 75 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PRINTSCALE' 76 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTDBQX' 77 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTDBQX' 78 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTQFQX' 79 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_XTQFQX' 80 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_QXCYQX' 81 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_QXCYQX' 82 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TKPAR0_CZY000' 83 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TKPAR0_CZY000' 84 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJZF0_CZY000' 85 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJZF0_CZY000' 86 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 87 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 88 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFXSSPM' 89 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFXSSPM' 90 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBSFCF' 91 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBSFCF' 92 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFLS' 93 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFLS' 94 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFHS' 95 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_EJBBCFHS' 96 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFABRFYDY' 97 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDSFABRFYDY' 98 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJCJD_WIDTHHEIGH' 99 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJCJD_WIDTHHEIGH' 100 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_RQDSFBSFYBXM' 101 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_RQDSFBSFYBXM' 102 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_YFSBGSJZSFJK' 103 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_YFSBGSJZSFJK' 104 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 105 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 106 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYFPSFXSFYBF' 107 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYFPSFXSFYBF' 108 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFBXLRNL' 109 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFBXLRNL' 110 09:20:37 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 111 09:20:37 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 112 09:20:37 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 113 09:20:37 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 114 09:20:37 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 115 09:20:37 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 116 09:20:37 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXSFCDLYJXM' 117 09:20:37 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXSFCDLYJXM' 118 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGS00' 119 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGS00' 120 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 121 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 122 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 123 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 124 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 125 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 126 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YTFSFYXCY' 127 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YTFSFYXCY' 128 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 129 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 130 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZY_SFZDXS' 131 09:20:37 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZY_SFZDXS' 132 09:20:37 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJKSSJ' 133 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJKSSJ' 134 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJJSSJ' 135 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_TJJSSJ' 136 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 137 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 138 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPWidth' 139 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPWidth' 140 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPHeigh' 141 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPHeigh' 142 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYSFJJBSJ' 143 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYSFJJBSJ' 144 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_SYDJKYDBQF' 145 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_SYDJKYDBQF' 146 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 147 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 148 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_QDXXZHYE' 149 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_QDXXZHYE' 150 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKDSFTD' 151 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKDSFTD' 152 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKSFAJJBSJ' 153 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_JKSFAJJBSJ' 154 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYJKDGS0' 155 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_ZYJKDGS0' 156 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJDJGS' 157 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YJJDJGS' 158 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBRQDFS' 159 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_YBRQDFS' 160 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 161 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 162 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFFZ' 163 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RYDJSFFZ' 164 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 165 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 166 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 167 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 168 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 169 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 170 09:20:38 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 171 09:20:38 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 172 09:20:38 SQL Prepare: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 173 09:20:38 SQL Execute: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 174 09:20:38 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_FPTOP' 175 09:20:38 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_FPTOP' 176 09:20:38 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_SFQZGSYB' 177 09:20:38 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_SFQZGSYB' 178 09:20:38 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00='ZY_YJJDYE' 179 09:20:38 SQL Execute: ORACLE - select * from xt_xtcs00 where name00='ZY_YJJDYE' 180 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 181 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 182 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDFPXMSFDY' 183 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_RQDFPXMSFDY' 184 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BRCYSFDYBASY' 185 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BRCYSFDYBASY' 186 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_LeftPage' 187 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_LeftPage' 188 09:20:38 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_TopPage' 189 09:20:38 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_BASY_TopPage' 190 09:20:38 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='ZY_CRYTJSFAKS' 191 09:20:38 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='ZY_CRYTJSFAKS' 192 09:20:38 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='ZY_HZQDDYSFXSYBFY' 193 09:20:38 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='ZY_HZQDDYSFXSYBFY' 194 09:20:38 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS') 195 09:20:38 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS') 196 09:20:38 SQL Prepare: ORACLE - select upper(value0) from XT_XTCS00 where NAME00 = 'ZY_RQDGSCS' 197 09:20:38 SQL Execute: ORACLE - select upper(value0) from XT_XTCS00 where NAME00 = 'ZY_RQDGSCS' 198 09:20:38 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFSYPANHJK','ZY_KP_QKPYHFS','ZY_JKDJXJYJSFXS','ZY_YLFYMXTJHS','ZY_YLFYMXTJLS','ZY_YLFYMXZ_SFCF', 'ZY_QDSFXSJMJE','ZY_SFSXYJJE','MZ_ZY_YJJPJ_IDColor','ZY_YJJSFSKHYH','ZY_YBRYSFSYDT','ZY_XNHBRSFCSICKH','ZY_NHBRSFCSJBZD','ZY_CYBRFYYSZD','ZY_JSXSGS') 199 09:20:38 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_SFSYPANHJK','ZY_KP_QKPYHFS','ZY_JKDJXJYJSFXS','ZY_YLFYMXTJHS','ZY_YLFYMXTJLS','ZY_YLFYMXZ_SFCF', 'ZY_QDSFXSJMJE','ZY_SFSXYJJE','MZ_ZY_YJJPJ_IDColor','ZY_YJJSFSKHYH','ZY_YBRYSFSYDT','ZY_XNHBRSFCSICKH','ZY_NHBRSFCSJBZD','ZY_CYBRFYYSZD','ZY_JSXSGS') 200 09:20:38 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='9998' 201 09:20:38 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='9998' 202 09:20:42 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 203 09:20:42 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='5' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 204 09:20:42 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 205 09:20:42 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 206 09:20:42 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 ((476= 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=476)))) 207 09:20:42 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 ((476= 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=476)))) 208 09:20:42 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 209 09:20:42 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 210 09:20:42 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 211 09:20:42 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 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=476)))) 212 09:20:42 SQL Prepare: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 213 09:20:42 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 214 09:20:42 SQL Prepare: ORACLE - Commit 215 09:20:42 SQL Execute: ORACLE - Commit 216 09:20:45 SQL Prepare: ORACLE - select * from VW_ZY_DBQXB0 where BZ0000 = '2' 217 09:20:45 SQL Execute: ORACLE - select * from VW_ZY_DBQXB0 where BZ0000 = '2' 218 09:20:52 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 219 09:20:52 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 220 09:20:52 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 221 09:20:52 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 222 09:20:52 SQL Prepare: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' and CZBZ00 <> '2' order by bh0000 223 09:20:52 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' and CZBZ00 <> '2' order by bh0000 224 09:20:53 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 225 09:20:53 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 226 09:21:57 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 227 09:21:57 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 228 09:22:17 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 229 09:22:17 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 230 09:22:36 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 231 09:22:36 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 232 09:22:38 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 233 09:22:38 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 234 09:22:40 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 235 09:22:40 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 236 09:25:11 SQL Prepare: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END; 237 09:25:11 SQL Execute: ORACLE - BEGIN "SP_ZY_BRDB00_CIR000"; END;