1 16:52:21 Log started for: 门诊挂号收费管理系统 2 16:52:22 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.0.15','4',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 16:52:22 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.0.15','4',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 16:52:22 SQL Error: ORACLE - ORA-00942: 表或视图不存在 5 16:52:22 SQL Data In: ORACLE - Rows affected = 0 6 16:52:22 SQL Prepare: ORACLE - RollBack 7 16:52:22 SQL Execute: ORACLE - RollBack 8 16:52:22 SQL Data In: ORACLE - Rows affected = 0 9 16:52:22 SQL Prepare: ORACLE - Select SYSDATE from Dual 10 16:52:22 SQL Execute: ORACLE - Select SYSDATE from Dual 11 16:52:22 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 12 16:52:22 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 13 16:52:22 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 14 16:52:22 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 15 16:52:22 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 16 16:52:22 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 17 16:52:22 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 18 16:52:22 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 19 16:52:22 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='4' 20 16:52:22 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='4' 21 16:52:24 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='024')) order by BH0000 22 16:52:24 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='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='024')) order by BH0000 23 16:52:25 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '024'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='024')) 24 16:52:25 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '024'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='024')) 25 16:52:25 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='024' and CZBZ00='1' 26 16:52:25 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='024' and CZBZ00='1' 27 16:52:25 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 28 16:52:25 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 16:52:25 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 16:52:25 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 31 16:52:25 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 32 16:52:25 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 33 16:52:25 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 34 16:52:25 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 35 16:52:25 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(355939,641,'smfy-15','4',nvl('225972',' '),'',240) 36 16:52:25 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(355939,641,'smfy-15','4',nvl('225972',' '),'',240) 37 16:52:25 SQL Data In: ORACLE - Rows affected = 1 38 16:52:25 SQL Prepare: ORACLE - Commit 39 16:52:25 SQL Execute: ORACLE - Commit 40 16:52:25 SQL Data In: ORACLE - Rows affected = 0 41 16:52:25 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 240 42 16:52:25 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 240 43 16:52:25 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.15' 44 16:52:25 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.15' 45 16:52:25 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 46 16:52:25 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 47 16:52:25 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 240 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 48 16:52:25 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 240 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 49 16:52:25 SQL Error: ORACLE - ORA-00942: 表或视图不存在 50 16:52:25 SQL Data In: ORACLE - Rows affected = 0 51 16:52:25 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20100817' 52 16:52:25 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20100817' 53 16:52:25 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 54 16:52:25 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 55 16:52:25 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 56 16:52:25 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 57 16:52:25 SQL Prepare: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 58 16:52:25 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 59 16:52:25 SQL Prepare: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 60 16:52:25 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 61 16:52:25 SQL Prepare: ORACLE - select sysdate nowtime from dual 62 16:52:25 SQL Execute: ORACLE - select sysdate nowtime from dual 63 16:52:25 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 641 64 16:52:25 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 641 65 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,1) VALUE from XT_XTCS00 where NAME00 = 'GHYXTS' 66 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,1) VALUE from XT_XTCS00 where NAME00 = 'GHYXTS' 67 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PJHSC0' 68 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PJHSC0' 69 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_DYYBFP' 70 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_DYYBFP' 71 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZBLH0' 72 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZBLH0' 73 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00' 74 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JEQZ00' 75 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_YBJEQZ' 76 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_YBJEQZ' 77 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZHTYJE' 78 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZHTYJE' 79 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZHBJJE' 80 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_ZHBJJE' 81 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PJDKDY' 82 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PJDKDY' 83 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_SRWS_YB' 84 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_SRWS_YB' 85 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_CZFS_YB' 86 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_CZFS_YB' 87 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_YJDYEDY' 88 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_YJDYEDY' 89 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'MZ_BLGBF00' 90 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'MZ_BLGBF00' 91 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFMXJE_SRWS' 92 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFMXJE_SRWS' 93 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_YZMXJE_SRWS' 94 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_YZMXJE_SRWS' 95 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_SRWS' 96 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_SRWS' 97 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_CZFS' 98 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFZJE_CZFS' 99 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFMXJE_CZFS' 100 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_CFMXJE_CZFS' 101 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_YZMXJE_CZFS' 102 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'YF_YZMXJE_CZFS' 103 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_SFYJS0_BZ0000' 104 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_SFYJS0_BZ0000' 105 16:52:25 SQL Prepare: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'SF_GHD000_PRINT0' 106 16:52:25 SQL Execute: ORACLE - select NVL(VALUE0,0) VALUE0 from XT_XTCS00 where NAME00 = 'SF_GHD000_PRINT0' 107 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 108 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 109 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_TKPAR0_CZY000' 110 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_TKPAR0_CZY000' 111 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PARAMS_GHYXTS' 112 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PARAMS_GHYXTS' 113 16:52:25 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 114 16:52:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'ZY_RQDZZ0_SETUP0' 115 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 116 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageWidth' 117 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 118 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageHeigh' 119 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 120 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 121 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDLX0' 122 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDLX0' 123 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDSFTD' 124 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDSFTD' 125 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 126 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYJZK' 127 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 128 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 129 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 130 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 131 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBGHFJF' 132 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBGHFJF' 133 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 134 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBBRXB' 135 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPWidth' 136 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPWidth' 137 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPHeigh' 138 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPHeigh' 139 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPWidth' 140 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPWidth' 141 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPHeigh' 142 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPHeigh' 143 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDWidth' 144 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDWidth' 145 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDHeigh' 146 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHDHeigh' 147 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SF_SFZDXS' 148 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SF_SFZDXS' 149 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'YF_ZYFJF_YPNM00' 150 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'YF_ZYFJF_YPNM00' 151 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZSFJJBSJ' 152 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZSFJJBSJ' 153 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 154 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_PJLYXYLYQR' 155 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHXGSFBRCZ' 156 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHXGSFBRCZ' 157 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDSFTD' 158 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDSFTD' 159 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDJSFZDJS' 160 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDJSFZDJS' 161 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKSFAJJBSJ' 162 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKSFAJJBSJ' 163 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SYDJSBBGBF' 164 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SYDJSBBGBF' 165 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHCZSBBGBF' 166 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_GHCZSBBGBF' 167 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZJKDGS0' 168 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZJKDGS0' 169 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJDGS0' 170 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJDGS0' 171 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJTKDGS' 172 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJTKDGS' 173 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPGS' 174 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_NEWFPGS' 175 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FYJSMR0' 176 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FYJSMR0' 177 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 178 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_YBYYJKLM' 179 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_COMMIT_READICK' 180 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_COMMIT_READICK' 181 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBDJSLJE' 182 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBDJSLJE' 183 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBGHSFRQYZ' 184 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBGHSFRQYZ' 185 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBTKTSCZY' 186 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YBTKTSCZY' 187 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 188 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYICK' 189 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFXYLRJTDZ' 190 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFXYLRJTDZ' 191 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'MZ_FPGS00' 192 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'MZ_FPGS00' 193 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 194 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'ZY_FPGE00' 195 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFDYQD' 196 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFDYQD' 197 16:52:25 SQL Prepare: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 198 16:52:25 SQL Execute: ORACLE - select * FROM xt_xtcs00 where name00='SF_SFXMYBJK' 199 16:52:25 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_YBSFAGHDJS' 200 16:52:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_YBSFAGHDJS' 201 16:52:25 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_XGJKSJ' 202 16:52:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_XGJKSJ' 203 16:52:25 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_XMYBZLFID' 204 16:52:25 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'SF_XMYBZLFID' 205 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 206 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'XT_JKTQSJ' 207 16:52:25 SQL Prepare: ORACLE - select * FROM xt_xtcs00 where name00='SF_SF_HKSFSKF' 208 16:52:25 SQL Execute: ORACLE - select * FROM xt_xtcs00 where name00='SF_SF_HKSFSKF' 209 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JSATSBZ' 210 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JSATSBZ' 211 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TSGHSFZYXYBBR' 212 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TSGHSFZYXYBBR' 213 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_RQDTOPLEFT' 214 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_RQDTOPLEFT' 215 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_RQDBOTTOMRIGHT' 216 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_RQDBOTTOMRIGHT' 217 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZFPSFXSFYBF' 218 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZFPSFXSFYBF' 219 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JZKBRSFCSFDYCFD' 220 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JZKBRSFCSFDYCFD' 221 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFYXSFCDLYJXM' 222 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFYXSFCDLYJXM' 223 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 224 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJXMYXTS' 225 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFQYCZPJKPJK' 226 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFQYCZPJKPJK' 227 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_MZFPDYPLBH' 228 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_MZFPDYPLBH' 229 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_FPZRDYMS' 230 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_FPZRDYMS' 231 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_LJDLKPXTFS' 232 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_LJDLKPXTFS' 233 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYXMSMK' 234 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_SFSYXMSMK' 235 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJDSFTD' 236 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJDSFTD' 237 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJTKDSFTD' 238 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_YJJTKDSFTD' 239 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZQZTKSFDYFP' 240 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZQZTKSFDYFP' 241 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_MZGHPDYPLBH' 242 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_MZGHPDYPLBH' 243 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_SFZRDYGHFP' 244 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_SFZRDYGHFP' 245 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_SFQDZRXDTS' 246 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_SFQDZRXDTS' 247 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMYBFYDJSFKXZHLX' 248 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMYBFYDJSFKXZHLX' 249 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMFPSFXSYJJZE' 250 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMFPSFXSYJJZE' 251 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMFPQDSFXSZLXM' 252 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_XMFPQDSFXSZLXM' 253 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_BLHSFZDSC' 254 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_BLHSFZDSC' 255 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TYDWBRSFTGZZJZ' 256 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TYDWBRSFTGZZJZ' 257 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDJGBCBLHTDYJJC' 258 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_JKDJGBCBLHTDYJJC' 259 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_QSJDYJJZELB' 260 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_QSJDYJJZELB' 261 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_SFDM' 262 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'IC_SFDM' 263 16:52:25 SQL Prepare: ORACLE - select nvl(MZFPID,0) MZFPID from BM_YYSFXM where SFXMID=8000000144 264 16:52:25 SQL Execute: ORACLE - select nvl(MZFPID,0) MZFPID from BM_YYSFXM where SFXMID=8000000144 265 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_ICKFSFDDLC' 266 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_KP_ICKFSFDDLC' 267 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZJSSFXZTSBZ' 268 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_MZJSSFXZTSBZ' 269 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'YF_ZYJYF_SFDM' 270 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'YF_ZYJYF_SFDM' 271 16:52:25 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='SF_JKGBYDSX' 272 16:52:25 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='SF_JKGBYDSX' 273 16:52:25 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='SF_SFXSFYPJS' 274 16:52:25 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='SF_SFXSFYPJS' 275 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPSFZNYCZYBD' 276 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FPSFZNYCZYBD' 277 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FYWJZSFXZJS' 278 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_FYWJZSFXZJS' 279 16:52:25 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PRINTGHHZDY' 280 16:52:25 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PRINTGHHZDY' 281 16:52:25 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFFHCWSFJL','SF_MZFPSFDYYBGRZHYE','SF_YBJSTJSFASJJSTJ','SF_IC_XMJKKSFJE','SF_SFSYYBYKT','SF_JKDJXJYJSFXS','SF_TJZFSFSQLT','SF_QDSFXSJMJE','SF_SFSXYJJE','SF_SFXSBRDZ','SF_PRINTYJJPJZDY', 'SF_TJFYDZHSFKYTK','SF_YJJTKJESFXSFS','SF_YJJTKREDFONT','SF_ZCNHBRFYSFCSGYB','SF_ZFFPXMSFXSYBZFBL','SF_YJJFXJZDJEXZ','YS_SFXSYBZHYE','SF_ZHWHQX','SF_FYJSMRSX','SF_FPSFDYGWYJE','SF_MZSFYSZJHM') 282 16:52:25 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFFHCWSFJL','SF_MZFPSFDYYBGRZHYE','SF_YBJSTJSFASJJSTJ','SF_IC_XMJKKSFJE','SF_SFSYYBYKT','SF_JKDJXJYJSFXS','SF_TJZFSFSQLT','SF_QDSFXSJMJE','SF_SFSXYJJE','SF_SFXSBRDZ','SF_PRINTYJJPJZDY', 'SF_TJFYDZHSFKYTK','SF_YJJTKJESFXSFS','SF_YJJTKREDFONT','SF_ZCNHBRFYSFCSGYB','SF_ZFFPXMSFXSYBZFBL','SF_YJJFXJZDJEXZ','YS_SFXSYBZHYE','SF_ZHWHQX','SF_FYJSMRSX','SF_FPSFDYGWYJE','SF_MZSFYSZJHM') 283 16:52:25 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 284 16:52:25 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 285 16:52:30 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='4' and (( 641= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=641)))) 286 16:52:30 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='4' and (( 641= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=641)))) 287 16:52:30 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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 ((641= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=641)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 288 16:52:30 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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 ((641= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=641)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 289 16:52:30 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 ((641= 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=641)))) 290 16:52:30 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 ((641= 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=641)))) 291 16:52:30 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 292 16:52:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 293 16:52:30 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 641= 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=641)))) 294 16:52:30 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 641= 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=641)))) 295 16:52:30 SQL Prepare: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 296 16:52:30 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 297 16:52:30 SQL Data In: ORACLE - Rows affected = 0 298 16:52:30 SQL Prepare: ORACLE - Commit 299 16:52:30 SQL Execute: ORACLE - Commit 300 16:52:30 SQL Data In: ORACLE - Rows affected = 0 301 16:52:40 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 302 16:52:40 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 303 16:52:40 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 304 16:52:40 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 305 16:52:40 SQL Prepare: ORACLE - Select SYSDATE from Dual 306 16:52:40 SQL Execute: ORACLE - Select SYSDATE from Dual 307 16:52:40 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 308 16:52:40 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 309 16:52:40 SQL Prepare: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 310 16:52:40 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 311 16:52:40 SQL Data In: ORACLE - Rows affected = 1 312 16:52:40 SQL Prepare: ORACLE - Commit 313 16:52:40 SQL Execute: ORACLE - Commit 314 16:52:40 SQL Data In: ORACLE - Rows affected = 0 315 16:52:40 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 316 16:52:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 317 16:52:40 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 318 16:52:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 319 16:52:42 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMYB-NEW' and KLDH00 not in ('CK','JMCK') 320 16:52:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMYB-NEW' and KLDH00 not in ('CK','JMCK') 321 16:52:45 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'XMYB350204635308' and ICKNBH = 'XMYB350204635308' 322 16:52:45 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'XMYB350204635308' and ICKNBH = 'XMYB350204635308' 323 16:52:45 SQL Prepare: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =497730 324 16:52:45 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =497730 325 16:52:45 SQL Prepare: ORACLE - select * from VW_SF_BRGH00 where SFYY00 = 'N' and THRQ00 is null and BRID00 in (select brid00 from ic_yhxx00 where ickh00 = 'XMYB350204635308' ) and GHRQ00 > to_char(trunc(sysdate-1/4)-1,'YYYYMMDD' ) 326 16:52:45 SQL Execute: ORACLE - select * from VW_SF_BRGH00 where SFYY00 = 'N' and THRQ00 is null and BRID00 in (select brid00 from ic_yhxx00 where ickh00 = 'XMYB350204635308' ) and GHRQ00 > to_char(trunc(sysdate-1/4)-1,'YYYYMMDD' ) 327 16:52:45 SQL Prepare: ORACLE - select ICKH00 from ic_yhxx00 where brid00 = 497730 and ZT0000 = '1' 328 16:52:45 SQL Execute: ORACLE - select ICKH00 from ic_yhxx00 where brid00 = 497730 and ZT0000 = '1' 329 16:52:45 SQL Prepare: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = '1514236' 330 16:52:45 SQL Execute: ORACLE - select b.GHQXBZ from sf_brxxb0 a,BM_GHLBB0 b where a.GHLB00=b.LBBH00 AND GHH000 = '1514236' 331 16:52:45 SQL Prepare: ORACLE - select YBID00,YBKH00 from bm_brxxb0 where BRID00 = 497730 332 16:52:45 SQL Execute: ORACLE - select YBID00,YBKH00 from bm_brxxb0 where BRID00 = 497730 333 16:52:45 SQL Prepare: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =641 and SYBZ00 = 'Y' 334 16:52:45 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =641 and SYBZ00 = 'Y' 335 16:52:45 SQL Prepare: ORACLE - select * from bm_brjflb where jflbid in (0,1) 336 16:52:45 SQL Execute: ORACLE - select * from bm_brjflb where jflbid in (0,1) 337 16:52:45 SQL Prepare: ORACLE - select nvl(tydwid,0) tydwid,a.* from bm_brxxb0 a where brid00 = 497730 338 16:52:45 SQL Execute: ORACLE - select nvl(tydwid,0) tydwid,a.* from bm_brxxb0 a where brid00 = 497730 339 16:52:45 SQL Prepare: ORACLE - select * from ic_ybbrlb where YBLB00 = '1' 340 16:52:45 SQL Execute: ORACLE - select * from ic_ybbrlb where YBLB00 = '1' 341 16:52:45 SQL Prepare: ORACLE - select * from bm_ybbrlb where YBZXLB = '1' and YBBRLB ='0' 342 16:52:45 SQL Execute: ORACLE - select * from bm_ybbrlb where YBZXLB = '1' and YBBRLB ='0' 343 16:52:45 SQL Prepare: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=:1 and YBBRLB=:2 and YBZXLB=:3 344 16:52:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 345 16:52:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 346 16:52:45 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 347 16:52:45 SQL Execute: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=? and YBBRLB=? and YBZXLB=? 348 16:52:45 SQL Prepare: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = 1 and BRID00 = 497730 349 16:52:45 SQL Execute: ORACLE - select B.JFLBMC,A.* from sf_brzhxx A,BM_BRJFLB B where A.JFLBID = B.JFLBID and A.JFLBID = 1 and BRID00 = 497730 350 16:52:45 SQL Prepare: ORACLE - select * from yf_mzcf00 A where A.BCCFH0 is null and A.CFZT00 = '0' and A.BRID00 <> 0 and BRID00 = 497730 and NOT EXISTS( select 1 from YF_MZCFMX where CFLSH0 = A.CFLSH0 and THBZ00 <> '0') and A.GHH000 = '1514236' 351 16:52:45 SQL Execute: ORACLE - select * from yf_mzcf00 A where A.BCCFH0 is null and A.CFZT00 = '0' and A.BRID00 <> 0 and BRID00 = 497730 and NOT EXISTS( select 1 from YF_MZCFMX where CFLSH0 = A.CFLSH0 and THBZ00 <> '0') and A.GHH000 = '1514236' 352 16:52:45 SQL Prepare: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 = '1344364' 353 16:52:45 SQL Execute: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 = '1344364' 354 16:52:45 SQL Data In: ORACLE - Rows affected = 0 355 16:52:45 SQL Prepare: ORACLE - commit 356 16:52:45 SQL Execute: ORACLE - commit 357 16:52:45 SQL Data In: ORACLE - Rows affected = 0 358 16:52:45 SQL Prepare: ORACLE - select SF_MZ_PSCFYS('1514236','1344364') NFJJ00 from dual 359 16:52:45 SQL Execute: ORACLE - select SF_MZ_PSCFYS('1514236','1344364') NFJJ00 from dual 360 16:52:45 SQL Prepare: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 ='1344364' 361 16:52:45 SQL Execute: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 ='1344364' 362 16:52:45 SQL Prepare: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =:1 and A.YBZXLB=:2 and A.SFYP00 ='Y' 363 16:52:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8807.000000 364 16:52:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 365 16:52:45 SQL Execute: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =? and A.YBZXLB=? and A.SFYP00 ='Y' 366 16:52:45 SQL Prepare: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =:1 and A.YBZXLB=:2 and A.SFYP00 ='Y' 367 16:52:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8135.000000 368 16:52:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 369 16:52:45 SQL Execute: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =? and A.YBZXLB=? and A.SFYP00 ='Y' 370 16:52:45 SQL Prepare: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 = '1344365' 371 16:52:45 SQL Execute: ORACLE - update YF_MZCF00 A SET SFXJJZ='0' where A.SFXJJZ='1' and A.BCCFH0 is null and A.CFZT00 = '0' and A.CFLSH0 = '1344365' 372 16:52:45 SQL Data In: ORACLE - Rows affected = 0 373 16:52:45 SQL Prepare: ORACLE - commit 374 16:52:45 SQL Execute: ORACLE - commit 375 16:52:45 SQL Data In: ORACLE - Rows affected = 0 376 16:52:45 SQL Prepare: ORACLE - select SF_MZ_PSCFYS('1514236','1344365') NFJJ00 from dual 377 16:52:45 SQL Execute: ORACLE - select SF_MZ_PSCFYS('1514236','1344365') NFJJ00 from dual 378 16:52:45 SQL Prepare: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 ='1344365' 379 16:52:45 SQL Execute: ORACLE - select * from VW_SF_CFMX00 where CFLSH0 ='1344365' 380 16:52:45 SQL Prepare: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =:1 and A.YBZXLB=:2 and A.SFYP00 ='Y' 381 16:52:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8680.000000 382 16:52:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 383 16:52:45 SQL Execute: ORACLE - select B.XMMC00 YBXMMC,A.* from VW_SF_YBSFDY A,BM_YBSFXM B where A.YBXMBH = B.XMBH00 and A.YBZXLB = B.YBZXLB and A.SFXMID =? and A.YBZXLB=? and A.SFYP00 ='Y' 384 16:52:47 SQL Prepare: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 497730 and YJDJH0 not in ( 0 ) and GHH000 = '1514236' 385 16:52:47 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 497730 and YJDJH0 not in ( 0 ) and GHH000 = '1514236' 386 16:52:47 SQL Prepare: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 387 16:52:47 SQL Execute: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 388 16:52:47 SQL Prepare: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 389 16:52:47 SQL Execute: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 390 16:52:47 SQL Prepare: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 391 16:52:47 SQL Execute: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 392 16:52:48 SQL Prepare: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 393 16:52:48 SQL Execute: ORACLE - select * from VW_SF_YJYWMX where YJDJH0 ='' 394 16:52:48 SQL Prepare: ORACLE - Select SYSDATE from Dual 395 16:52:48 SQL Execute: ORACLE - Select SYSDATE from Dual 396 16:52:48 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 397 16:52:48 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 398 16:52:48 SQL Prepare: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 399 16:52:48 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='49' where NAME00='IC_BBH' 400 16:52:48 SQL Data In: ORACLE - Rows affected = 1 401 16:52:48 SQL Prepare: ORACLE - Commit 402 16:52:48 SQL Execute: ORACLE - Commit 403 16:52:48 SQL Data In: ORACLE - Rows affected = 0 404 16:52:48 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 405 16:52:48 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 406 16:52:48 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 407 16:52:48 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMJK' and KLDH00 not in ('CK','JMCK') 408 16:52:51 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMYB-NEW' and KLDH00 not in ('CK','JMCK') 409 16:52:51 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-XMYB-NEW' and KLDH00 not in ('CK','JMCK') 410 16:52:53 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'XMYB350204635308' and ICKNBH = 'XMYB350204635308' 411 16:52:53 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'XMYB350204635308' and ICKNBH = 'XMYB350204635308' 412 16:52:53 SQL Prepare: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =497730 413 16:52:53 SQL Execute: ORACLE - select * from sf_brzhxx where jflbid = 1 and brid00 =497730 414 16:52:53 SQL Prepare: ORACLE - select * from sf_brzhxx where 1 = 1 and JFLBID = 1 and BRID00 = 497730 415 16:52:53 SQL Execute: ORACLE - select * from sf_brzhxx where 1 = 1 and JFLBID = 1 and BRID00 = 497730 416 16:52:54 SQL Prepare: ORACLE - select nvl(trim(max(A.YBGHH0)),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghid00=1514236 and A.BRID00 = 497730 417 16:52:54 SQL Execute: ORACLE - select nvl(trim(max(A.YBGHH0)),0) YBGHH0 from SF_BRXXB0 A,BM_BMBM00 C where A.GHKS00 = C.BMBH00 and A.GHRQ00=to_char(sysdate,'YYYYMMDD') and a.ghid00=1514236 and A.BRID00 = 497730 418 16:52:54 SQL Prepare: ORACLE - Update sf_brxxb0 set ybghh0 = '000073645319' where BRID00 = 497730and ghid00=1514236 and ybghh0 = '0' 419 16:52:54 SQL Execute: ORACLE - Update sf_brxxb0 set ybghh0 = '000073645319' where BRID00 = 497730and ghid00=1514236 and ybghh0 = '0' 420 16:52:54 SQL Data In: ORACLE - Rows affected = 0 421 16:52:54 SQL Prepare: ORACLE - Commit 422 16:52:54 SQL Execute: ORACLE - Commit 423 16:52:54 SQL Data In: ORACLE - Rows affected = 0 424 16:52:56 SQL Prepare: ORACLE - select YBLB00 from IC_YBBRLB where YBMC00 = '厦门市社保中心' 425 16:52:56 SQL Execute: ORACLE - select YBLB00 from IC_YBBRLB where YBMC00 = '厦门市社保中心' 426 16:52:56 SQL Prepare: ORACLE - BEGIN "SP_IC_YBHMD0_COMMIT" (V_YBZXLB => :V_YBZXLB,V_YBKH00 => :V_YBKH00,V_YBID00 => :V_YBID00,V_XM0000 => :V_XM0000,V_ZT0000 => :V_ZT0000); END; 427 16:52:56 SQL Data In: ORACLE - Param = 1, Name = V_YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 428 16:52:56 SQL Data In: ORACLE - Param = 2, Name = V_YBKH00, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 350204635308 429 16:52:56 SQL Data In: ORACLE - Param = 3, Name = V_YBID00, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 350702198109150027 430 16:52:56 SQL Data In: ORACLE - Param = 4, Name = V_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 洪丽欢 431 16:52:56 SQL Data In: ORACLE - Param = 5, Name = V_ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 432 16:52:56 SQL Execute: ORACLE - BEGIN "SP_IC_YBHMD0_COMMIT" (V_YBZXLB => :V_YBZXLB,V_YBKH00 => :V_YBKH00,V_YBID00 => :V_YBID00,V_XM0000 => :V_XM0000,V_ZT0000 => :V_ZT0000); END; 433 16:52:56 SQL Prepare: ORACLE - update SF_BRZHXX set YBYJS0 = 928.51 ,YBYZF0 = 928.51 where BRID00=497730 and JFLBID = 1 434 16:52:56 SQL Execute: ORACLE - update SF_BRZHXX set YBYJS0 = 928.51 ,YBYZF0 = 928.51 where BRID00=497730 and JFLBID = 1 435 16:52:56 SQL Data In: ORACLE - Rows affected = 1 436 16:52:56 SQL Prepare: ORACLE - Commit 437 16:52:56 SQL Execute: ORACLE - Commit 438 16:52:56 SQL Data In: ORACLE - Rows affected = 0 439 16:52:56 SQL Prepare: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 497730 and YJDJH0 not in ( 0 ) and GHH000 = '1514236' 440 16:52:56 SQL Execute: ORACLE - select * from VW_SF_YJYW00 where CXDJH0 is null and SFDJH0+0 = 0 and XMZT00 = '1' and BRID00 = 497730 and YJDJH0 not in ( 0 ) and GHH000 = '1514236' 441 16:52:56 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 442 16:52:56 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 443 16:52:56 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 444 16:52:56 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 445 16:52:56 SQL Prepare: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 446 16:52:56 SQL Execute: ORACLE - select SQ_SF_BRJFB0_DJH000.nextval DJH000 from dual 447 16:52:56 SQL Prepare: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 448 16:52:56 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1344364 449 16:52:56 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535367.000000 450 16:52:56 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 451 16:52:56 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 452 16:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 453 16:52:56 SQL Prepare: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 454 16:52:56 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1344365 455 16:52:56 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535367.000000 456 16:52:56 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 457 16:52:56 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 458 16:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 459 16:52:56 SQL Prepare: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 460 16:52:56 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 461 16:52:56 SQL Data In: ORACLE - Param = 2, Name = AS_MZH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1514236 462 16:52:56 SQL Data In: ORACLE - Param = 3, Name = AD_MZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1514236.000000 463 16:52:56 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 464 16:52:56 SQL Data In: ORACLE - Param = 5, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497730.000000 465 16:52:56 SQL Data In: ORACLE - Param = 6, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 洪丽欢 466 16:52:56 SQL Data In: ORACLE - Param = 7, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 467 16:52:56 SQL Data In: ORACLE - Param = 8, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 641.000000 468 16:52:56 SQL Data In: ORACLE - Param = 9, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 骆宏玲 469 16:52:56 SQL Data In: ORACLE - Param = 10, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 240.000000 470 16:52:56 SQL Data In: ORACLE - Param = 11, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535367.000000 471 16:52:56 SQL Data In: ORACLE - Param = 12, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 472 16:52:56 SQL Data In: ORACLE - Param = 13, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 473 16:52:56 SQL Data In: ORACLE - Param = 14, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 474 16:52:56 SQL Data In: ORACLE - Param = 15, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 475 16:52:56 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 476 16:52:56 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 477 16:52:56 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_REG000" (AS_YBDJH0 => :AS_YBDJH0,AS_MZH000 => :AS_MZH000,AD_MZID00 => :AD_MZID00,AS_JFLBMC => :AS_JFLBMC,AD_BRID00 => :AD_BRID00,AS_XM0000 => :AS_XM0000,AD_BRFB00 => :AD_BRFB00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AD_DJH000 => :AD_DJH000,AD_HJJE00 => :AD_HJJE00,AD_ZFJE00 => :AD_ZFJE00,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 478 16:52:56 SQL Prepare: ORACLE - update SF_BRZHXX set YBYJS0=0,YBYZF0=0 where BRID00=497730 and JFLBID = 1 479 16:52:56 SQL Execute: ORACLE - update SF_BRZHXX set YBYJS0=0,YBYZF0=0 where BRID00=497730 and JFLBID = 1 480 16:52:56 SQL Data In: ORACLE - Rows affected = 1 481 16:52:57 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 482 16:52:57 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 483 16:52:57 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 484 16:52:57 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 485 16:52:57 SQL Prepare: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =641 and SYBZ00 = 'Y' 486 16:52:57 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0 =641 and SYBZ00 = 'Y' 487 16:52:57 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 488 16:52:57 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 489 16:52:57 SQL Prepare: ORACLE - select A.*,B.JFLBMC,C.*,D.FBMC00 from sf_brzhxx A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = 497730 and A.JFLBID = 1 490 16:52:57 SQL Execute: ORACLE - select A.*,B.JFLBMC,C.*,D.FBMC00 from sf_brzhxx A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = 497730 and A.JFLBID = 1 491 16:52:57 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 492 16:52:57 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 493 16:52:57 SQL Prepare: ORACLE - select * from ic_ybbrlb where YBLB00 = '1' 494 16:52:57 SQL Execute: ORACLE - select * from ic_ybbrlb where YBLB00 = '1' 495 16:52:57 SQL Prepare: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=:1 and YBBRLB=:2 and YBZXLB=:3 496 16:52:57 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 497 16:52:57 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 498 16:52:57 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 499 16:52:57 SQL Execute: ORACLE - select COUNT(1) JLS from BM_BRZTQK where FBBH00=? and YBBRLB=? and YBZXLB=? 500 16:52:57 SQL Prepare: ORACLE - select b.bmmc00 ghksmc,b.bmbh00 from SF_BRXXB0 A,BM_BMBM00 b where 1 = 1 and a.ghrq00=(select max(ghrq00) from SF_BRXXB0 where 1 = 1 and BRID00 = 497730 and LBBH00 = 1) and a.ghks00=b.bmbh00 and A.BRID00 = 497730 and A.LBBH00 = 1 501 16:52:57 SQL Execute: ORACLE - select b.bmmc00 ghksmc,b.bmbh00 from SF_BRXXB0 A,BM_BMBM00 b where 1 = 1 and a.ghrq00=(select max(ghrq00) from SF_BRXXB0 where 1 = 1 and BRID00 = 497730 and LBBH00 = 1) and a.ghks00=b.bmbh00 and A.BRID00 = 497730 and A.LBBH00 = 1 502 16:52:57 SQL Prepare: ORACLE - select NVL(max(YBGHH0),0) YBLSH0 from SF_BRXXB0 where 1=1 and LBBH00 = 1 and GHRQ00=to_char(sysdate,'YYYYMMDD') and BRID00 = 497730 503 16:52:57 SQL Execute: ORACLE - select NVL(max(YBGHH0),0) YBLSH0 from SF_BRXXB0 where 1=1 and LBBH00 = 1 and GHRQ00=to_char(sysdate,'YYYYMMDD') and BRID00 = 497730 504 16:52:57 SQL Prepare: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and A.HJJE00<>0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 505 16:52:57 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and A.HJJE00<>0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 506 16:52:57 SQL Prepare: ORACLE - select 0 FPXMID,'合计' XMMC00, 92.43 JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 AND A.HJJE00<>0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' group by C.FPXMID, C.XMMC00 507 16:52:57 SQL Execute: ORACLE - select 0 FPXMID,'合计' XMMC00, 92.43 JE0000 from dual union all select C.FPXMID,C.XMMC00,sum(A.HJJE00) JE0000 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 AND A.HJJE00<>0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' group by C.FPXMID, C.XMMC00 508 16:52:57 SQL Prepare: ORACLE - select A.*,D.CZYXM0,D.MZH000 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and A.HJJE00 <> 0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 509 16:52:57 SQL Execute: ORACLE - select A.*,D.CZYXM0,D.MZH000 from sf_fymx00 A,bm_yysfxm B,sf_brfy00 D where A.XMBH00 = B.SFXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and A.HJJE00 <> 0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 510 16:52:59 SQL Prepare: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 511 16:52:59 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and D.BRID00 = 497730 and D.JFLBID = 1 and D.CZRQ00>= '20100817' and D.CZRQ00<= '20100817' 512 16:53:00 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 513 16:53:00 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 514 16:53:00 SQL Prepare: ORACLE - select sum(a.CFZJE0) JE0000 from yf_mzcf00 a,sf_brxxb0 b where a.ghid00=b.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and a.BCCFH0 is null and a.CFZT00 ='0' and a.BRID00 = 497730 515 16:53:00 SQL Execute: ORACLE - select sum(a.CFZJE0) JE0000 from yf_mzcf00 a,sf_brxxb0 b where a.ghid00=b.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and a.BCCFH0 is null and a.CFZT00 ='0' and a.BRID00 = 497730 516 16:53:00 SQL Prepare: ORACLE - select sum(a.ZJE000) JE0000 from YJ_YW0000 a,sf_brxxb0 b where a.zyghid=b.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and a.MZZYBZ <> '1' and a.XMZT00 = '1' and a.CXDJH0 is null and a.SFDJH0+0 = 0 and a.BRID00 = 497730 517 16:53:00 SQL Execute: ORACLE - select sum(a.ZJE000) JE0000 from YJ_YW0000 a,sf_brxxb0 b where a.zyghid=b.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and a.MZZYBZ <> '1' and a.XMZT00 = '1' and a.CXDJH0 is null and a.SFDJH0+0 = 0 and a.BRID00 = 497730 518 16:53:00 SQL Prepare: ORACLE - select count(1) cfzjl0 from YF_MZCF00 D,sf_brxxb0 c where d.ghid00=c.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and D.CFZT00 in( '0','5') and exists ( select 1 from yf_mzcf00 A, sf_brfy00 B where A.DJH000 = B.DJH000 and B.JZDH00+0 = 0 and d.bccfh0=a.cflsh0 and b.brid00=d.brid00 ) and d.brid00=497730 519 16:53:00 SQL Execute: ORACLE - select count(1) cfzjl0 from YF_MZCF00 D,sf_brxxb0 c where d.ghid00=c.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and D.CFZT00 in( '0','5') and exists ( select 1 from yf_mzcf00 A, sf_brfy00 B where A.DJH000 = B.DJH000 and B.JZDH00+0 = 0 and d.bccfh0=a.cflsh0 and b.brid00=d.brid00 ) and d.brid00=497730 520 16:53:00 SQL Prepare: ORACLE - select count(1) yjzjl0 from YJ_YW0000 D,sf_brxxb0 c where d.zyghid=c.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and exists ( select 1 from YJ_YW0000 a,sf_brfy00 b where a.SFDJH0=b.djh000 and b.JZDH00+0 = 0 and d.cxdjh0=a.yjdjh0 and b.brid00=d.brid00 ) and D.SFDJH0+0 = 0 and d.brid00=497730 521 16:53:00 SQL Execute: ORACLE - select count(1) yjzjl0 from YJ_YW0000 D,sf_brxxb0 c where d.zyghid=c.ghid00 and GHRQ00 > to_char(trunc(SysDate-1/4)-GHYXTS,'YYYYMMDD') and exists ( select 1 from YJ_YW0000 a,sf_brfy00 b where a.SFDJH0=b.djh000 and b.JZDH00+0 = 0 and d.cxdjh0=a.yjdjh0 and b.brid00=d.brid00 ) and D.SFDJH0+0 = 0 and d.brid00=497730 522 16:53:00 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 523 16:53:00 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 524 16:53:01 SQL Prepare: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 525 16:53:01 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 526 16:53:01 SQL Data In: ORACLE - Param = 2, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100817 527 16:53:01 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100817 528 16:53:01 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 529 16:53:01 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 530 16:53:01 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497730.000000 531 16:53:01 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 532 16:53:01 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 洪丽欢 533 16:53:01 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 534 16:53:01 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 535 16:53:01 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 92.430000 536 16:53:01 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 537 16:53:01 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 538 16:53:01 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 92.430000 539 16:53:01 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 540 16:53:01 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 541 16:53:01 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 542 16:53:01 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 543 16:53:01 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 92.430000 544 16:53:01 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 641.000000 545 16:53:01 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 骆宏玲 546 16:53:01 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 240.000000 547 16:53:01 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 548 16:53:01 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 549 16:53:01 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 550 16:53:01 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 551 16:53:01 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 552 16:53:01 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 553 16:53:01 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 554 16:53:01 SQL Data In: ORACLE - Param = 30, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 555 16:53:01 SQL Data In: ORACLE - Param = 31, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 556 16:53:01 SQL Data In: ORACLE - Param = 32, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 557 16:53:01 SQL Data In: ORACLE - Param = 33, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 558 16:53:01 SQL Data In: ORACLE - Param = 34, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 559 16:53:01 SQL Data In: ORACLE - Param = 35, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 560 16:53:01 SQL Data In: ORACLE - Param = 36, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 561 16:53:01 SQL Data In: ORACLE - Param = 37, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 562 16:53:01 SQL Data In: ORACLE - Param = 38, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 563 16:53:01 SQL Data In: ORACLE - Param = 39, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 564 16:53:01 SQL Data In: ORACLE - Param = 40, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 565 16:53:01 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AD_GWYDJH => :AD_GWYDJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 566 16:53:01 SQL Prepare: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 567 16:53:01 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497730.000000 568 16:53:01 SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 569 16:53:01 SQL Data In: ORACLE - Param = 3, Name = AS_GHH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 570 16:53:01 SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 厦门市社保中心 571 16:53:01 SQL Data In: ORACLE - Param = 5, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1570647.000000 572 16:53:01 SQL Data In: ORACLE - Param = 6, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 573 16:53:01 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 574 16:53:01 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 575 16:53:01 SQL Execute: ORACLE - BEGIN "SP_SF_MZSF00_YBJK00" (AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_GHH000 => :AS_GHH000,AS_YBMC00 => :AS_YBMC00,AD_JZDH00 => :AD_JZDH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 576 16:53:01 SQL Prepare: ORACLE - Update sf_brxxb0 set ybghh0 = '000073645319 ' where brid00 = 497730 and ybghh0 = '0' 577 16:53:01 SQL Execute: ORACLE - Update sf_brxxb0 set ybghh0 = '000073645319 ' where brid00 = 497730 and ybghh0 = '0' 578 16:53:01 SQL Data In: ORACLE - Rows affected = 0 579 16:53:01 SQL Prepare: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT,max(YSXM00) YSXM00 from BM_SFCFMX_TEMP00 where ID0000 = 237264 580 16:53:01 SQL Execute: ORACLE - select COUNT(*) NUM, NVL(SUM(XMJE00),0) AMOUNT,max(YSXM00) YSXM00 from BM_SFCFMX_TEMP00 where ID0000 = 237264 581 16:53:01 SQL Prepare: ORACLE - select count(*) ZJL,sum(decode(sign(HJJE00),-1,1,0)) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 497730 and mzid00 in (select ghid00 from sf_brxxb0 where ybghh0= '000073645319 ') 582 16:53:01 SQL Execute: ORACLE - select count(*) ZJL,sum(decode(sign(HJJE00),-1,1,0)) CXJL from sf_jzb000 where YBDJH0<>'0' AND BRID00 = 497730 and mzid00 in (select ghid00 from sf_brxxb0 where ybghh0= '000073645319 ') 583 16:53:01 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = 237264 and BZ0000 = 'Y' 584 16:53:01 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = 237264 and BZ0000 = 'Y' 585 16:53:01 SQL Prepare: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = 237264 and BZ0000 = 'N' 586 16:53:01 SQL Execute: ORACLE - select * from BM_SFCF00_TEMP00 where ID0000 = 237264 and BZ0000 = 'N' 587 16:53:01 SQL Prepare: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = 237264 588 16:53:01 SQL Execute: ORACLE - select * from BM_SFCFMX_TEMP00 where ID0000 = 237264 589 16:53:04 SQL Prepare: ORACLE - BEGIN "SP_SF_YBJSDJ" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_YBLB00 => :AS_YBLB00,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_ZFJE00 => :AD_ZFJE00,AD_TCJJZF => :AD_TCJJZF,AD_GRZHZF => :AD_GRZHZF,AD_YBXJZF => :AD_YBXJZF,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_GWYBZ0 => :AD_GWYBZ0,AD_BCKBCS => :AD_BCKBCS,AD_JJZFE0 => :AD_JJZFE0,AD_JJDJH0 => :AD_JJDJH0,AD_SYBXZF => :AD_SYBXZF,AD_SYDJH0 => :AD_SYDJH0,AD_FYBFY0 => :AD_FYBFY0,AD_SBTJDH => :AD_SBTJDH,AD_SBZHDH => :AD_SBZHDH,AD_SBZFJE => :AD_SBZFJE,AD_SBTJJE => :AD_SBTJJE,AD_SBZHJE => :AD_SBZHJE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_GWYDJH => :AD_GWYDJH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 590 16:53:04 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 000078558956 591 16:53:04 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1570647.000000 592 16:53:04 SQL Data In: ORACLE - Param = 3, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 593 16:53:04 SQL Data In: ORACLE - Param = 4, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 594 16:53:04 SQL Data In: ORACLE - Param = 5, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535369.000000 595 16:53:04 SQL Data In: ORACLE - Param = 6, Name = AD_GZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535368.000000 596 16:53:04 SQL Data In: ORACLE - Param = 7, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.700000 597 16:53:04 SQL Data In: ORACLE - Param = 8, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 598 16:53:04 SQL Data In: ORACLE - Param = 9, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 88.730000 599 16:53:04 SQL Data In: ORACLE - Param = 10, Name = AD_YBXJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.700000 600 16:53:04 SQL Data In: ORACLE - Param = 11, Name = AD_YLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 601 16:53:04 SQL Data In: ORACLE - Param = 12, Name = AD_CFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 602 16:53:04 SQL Data In: ORACLE - Param = 13, Name = AD_GWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 603 16:53:04 SQL Data In: ORACLE - Param = 14, Name = AD_BCKBCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 604 16:53:04 SQL Data In: ORACLE - Param = 15, Name = AD_JJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 605 16:53:04 SQL Data In: ORACLE - Param = 16, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535372.000000 606 16:53:04 SQL Data In: ORACLE - Param = 17, Name = AD_SYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 607 16:53:04 SQL Data In: ORACLE - Param = 18, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535373.000000 608 16:53:04 SQL Data In: ORACLE - Param = 19, Name = AD_FYBFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.700000 609 16:53:04 SQL Data In: ORACLE - Param = 20, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535371.000000 610 16:53:04 SQL Data In: ORACLE - Param = 21, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535370.000000 611 16:53:04 SQL Data In: ORACLE - Param = 22, Name = AD_SBZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 612 16:53:04 SQL Data In: ORACLE - Param = 23, Name = AD_SBTJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 613 16:53:04 SQL Data In: ORACLE - Param = 24, Name = AD_SBZHJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 614 16:53:04 SQL Data In: ORACLE - Param = 25, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100817 615 16:53:04 SQL Data In: ORACLE - Param = 26, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:11:00 616 16:53:04 SQL Data In: ORACLE - Param = 27, Name = AD_GWYDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12535374.000000 617 16:53:04 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 618 16:53:04 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 619 16:53:04 SQL Data In: ORACLE - Param = 30, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 620 16:53:04 SQL Data In: ORACLE - Param = 31, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 621 16:53:04 SQL Execute: ORACLE - BEGIN "SP_SF_YBJSDJ" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_YBLB00 => :AS_YBLB00,AD_ZFDJH0 => :AD_ZFDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_GZDJH0 => :AD_GZDJH0,AD_ZFJE00 => :AD_ZFJE00,AD_TCJJZF => :AD_TCJJZF,AD_GRZHZF => :AD_GRZHZF,AD_YBXJZF => :AD_YBXJZF,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_GWYBZ0 => :AD_GWYBZ0,AD_BCKBCS => :AD_BCKBCS,AD_JJZFE0 => :AD_JJZFE0,AD_JJDJH0 => :AD_JJDJH0,AD_SYBXZF => :AD_SYBXZF,AD_SYDJH0 => :AD_SYDJH0,AD_FYBFY0 => :AD_FYBFY0,AD_SBTJDH => :AD_SBTJDH,AD_SBZHDH => :AD_SBZHDH,AD_SBZFJE => :AD_SBZFJE,AD_SBTJJE => :AD_SBTJJE,AD_SBZHJE => :AD_SBZHJE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_GWYDJH => :AD_GWYDJH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 622 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 623 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 624 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 625 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 626 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 627 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 628 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 629 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 630 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 631 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 632 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 633 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 634 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 635 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 636 16:53:04 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 637 16:53:04 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 638 16:53:04 SQL Prepare: ORACLE - BEGIN "SP_SF_FYMX00_XMZCF0" (AD_JZDH00 => :AD_JZDH00,AD_BRID00 => :AD_BRID00,AD_KDKS00 => :AD_KDKS00,AD_KDYS00 => :AD_KDYS00,AD_ZXKS00 => :AD_ZXKS00,AD_ZXYS00 => :AD_ZXYS00,AD_YBZJE0 => :AD_YBZJE0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 639 16:53:04 SQL Data In: ORACLE - Param = 1, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1570647.000000 640 16:53:04 SQL Data In: ORACLE - Param = 2, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497730.000000 641 16:53:04 SQL Data In: ORACLE - Param = 3, Name = AD_KDKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 240.000000 642 16:53:04 SQL Data In: ORACLE - Param = 4, Name = AD_KDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 240.000000 643 16:53:04 SQL Data In: ORACLE - Param = 5, Name = AD_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 240.000000 644 16:53:04 SQL Data In: ORACLE - Param = 6, Name = AD_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 641.000000 645 16:53:04 SQL Data In: ORACLE - Param = 7, Name = AD_YBZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 92.430000 646 16:53:04 SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 647 16:53:04 SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 648 16:53:04 SQL Execute: ORACLE - BEGIN "SP_SF_FYMX00_XMZCF0" (AD_JZDH00 => :AD_JZDH00,AD_BRID00 => :AD_BRID00,AD_KDKS00 => :AD_KDKS00,AD_KDYS00 => :AD_KDYS00,AD_ZXKS00 => :AD_ZXKS00,AD_ZXYS00 => :AD_ZXYS00,AD_YBZJE0 => :AD_YBZJE0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 649 16:53:04 SQL Prepare: ORACLE - commit 650 16:53:04 SQL Execute: ORACLE - commit 651 16:53:04 SQL Data In: ORACLE - Rows affected = 0 652 16:53:04 SQL Prepare: ORACLE - select * from BM_PJLYQK where PJLXBM = 2 and PJSYR0 =641 and SYBZ00 = 'Y' 653 16:53:04 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 2 and PJSYR0 =641 and SYBZ00 = 'Y' 654 16:53:04 SQL Prepare: ORACLE - BEGIN "SP_SF_BRZHXX" (AD_BRID00 => :AD_BRID00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 655 16:53:04 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497730.000000 656 16:53:04 SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 641.000000 657 16:53:04 SQL Data In: ORACLE - Param = 3, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 骆宏玲 658 16:53:04 SQL Data In: ORACLE - Param = 4, Name = AS_JFLBMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 门诊预交金 659 16:53:04 SQL Data In: ORACLE - Param = 5, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -3.300000 660 16:53:04 SQL Data In: ORACLE - Param = 6, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 661 16:53:04 SQL Data In: ORACLE - Param = 7, Name = AD_BJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 662 16:53:04 SQL Data In: ORACLE - Param = 8, Name = AD_TYJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 663 16:53:04 SQL Data In: ORACLE - Param = 9, Name = AD_YXQFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 664 16:53:04 SQL Data In: ORACLE - Param = 10, Name = AS_ZFFSMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金 665 16:53:04 SQL Data In: ORACLE - Param = 11, Name = AS_ZPH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 666 16:53:04 SQL Data In: ORACLE - Param = 12, Name = AS_ZPKHYH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 667 16:53:04 SQL Data In: ORACLE - Param = 13, Name = AS_ZPDWMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 668 16:53:04 SQL Data In: ORACLE - Param = 14, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 669 16:53:04 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 670 16:53:04 SQL Data In: ORACLE - Param = 16, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 671 16:53:04 SQL Data In: ORACLE - Param = 17, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 672 16:53:04 SQL Data In: ORACLE - Param = 18, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 673 16:53:04 SQL Execute: ORACLE - BEGIN "SP_SF_BRZHXX" (AD_BRID00 => :AD_BRID00,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_JFLBMC => :AS_JFLBMC,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_BJJE00 => :AD_BJJE00,AD_TYJE00 => :AD_TYJE00,AD_YXQFJE => :AD_YXQFJE,AS_ZFFSMC => :AS_ZFFSMC,AS_ZPH000 => :AS_ZPH000,AS_ZPKHYH => :AS_ZPKHYH,AS_ZPDWMC => :AS_ZPDWMC,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AD_PJH000 => :AD_PJH000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 674 16:53:04 SQL Prepare: ORACLE - select * from sf_jzb000 where jzdh00=1570647 675 16:53:04 SQL Execute: ORACLE - select * from sf_jzb000 where jzdh00=1570647 676 16:53:04 SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 677 16:53:04 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='024' 678 16:53:04 SQL Prepare: ORACLE - select * from vw_sf_fp0000 where jzdh00=1570647 679 16:53:04 SQL Execute: ORACLE - select * from vw_sf_fp0000 where jzdh00=1570647 680 16:53:04 SQL Prepare: ORACLE - select YBID00, fbbh00 from BM_BRXXB0 where BRID00=497730 681 16:53:04 SQL Execute: ORACLE - select YBID00, fbbh00 from BM_BRXXB0 where BRID00=497730 682 16:53:04 SQL Prepare: ORACLE - select nvl(sum(hjje00),0) hjje00 from vw_sf_rqdmx3 where jzdh00=1570647 and xmbh00=8000000144 683 16:53:04 SQL Execute: ORACLE - select nvl(sum(hjje00),0) hjje00 from vw_sf_rqdmx3 where jzdh00=1570647 and xmbh00=8000000144 684 16:53:04 SQL Prepare: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =497730 685 16:53:04 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =497730 686 16:53:04 SQL Prepare: ORACLE - select nvl(sum(JFJE00),0) YJJZE0 from SF_BRJFB0 where JFLBID='1' and JFJE00>0 and BRID00=497730 and JFRQ00||JFSJ00<='2010081716:53:01' 687 16:53:04 SQL Execute: ORACLE - select nvl(sum(JFJE00),0) YJJZE0 from SF_BRJFB0 where JFLBID='1' and JFJE00>0 and BRID00=497730 and JFRQ00||JFSJ00<='2010081716:53:01' 688 16:53:04 SQL Prepare: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00= :1 AND A.BRID00= 497730 689 16:53:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1514236.000000 690 16:53:04 SQL Execute: ORACLE - select B.LBMC00 from SF_BRXXB0 A,BM_GHLBB0 B where A.GHLB00=B.LBBH00 AND A.GHID00= ? AND A.BRID00= 497730 691 16:53:04 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SF_TJPJDYXSFPBH' 692 16:53:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='SF_TJPJDYXSFPBH' 693 16:53:04 SQL Prepare: ORACLE - select * from SF_JZMX00 where xmje00<>0 and JZDH00 =1570647 order by XMBH00 694 16:53:04 SQL Execute: ORACLE - select * from SF_JZMX00 where xmje00<>0 and JZDH00 =1570647 order by XMBH00 695 16:53:04 SQL Prepare: ORACLE - select * from vw_sf_rqdmx3 where jzdh00=1570647 and xmbh00<>8000000144 696 16:53:04 SQL Execute: ORACLE - select * from vw_sf_rqdmx3 where jzdh00=1570647 and xmbh00<>8000000144 697 16:53:07 SQL Prepare: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,:1,:2,:3,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),:4,:5,:6,:7,:8) 698 16:53:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 002024 699 16:53:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1570647.000000 700 16:53:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 07539192 701 16:53:07 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 641.000000 702 16:53:07 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 骆宏玲 703 16:53:07 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 704 16:53:07 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 705 16:53:07 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 200, Scale = 0, Data = 成功:002024,07539192,92.43,闽财[2010]票字第30号 706 16:53:07 SQL Execute: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,?,?,?,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),?,?,?,?,?) 707 16:53:07 SQL Data In: ORACLE - Rows affected = 1 708 16:53:07 SQL Prepare: ORACLE - commit 709 16:53:07 SQL Execute: ORACLE - commit 710 16:53:07 SQL Data In: ORACLE - Rows affected = 0 711 16:53:07 SQL Prepare: ORACLE - select pjh000 from sf_jzb000 where jzdh00=1570647 712 16:53:07 SQL Execute: ORACLE - select pjh000 from sf_jzb000 where jzdh00=1570647 713 16:53:07 SQL Prepare: ORACLE - update sf_pjsyqk set pjxh00='07539192' where pjzt00='0' and fzpjh0=3859388 714 16:53:07 SQL Execute: ORACLE - update sf_pjsyqk set pjxh00='07539192' where pjzt00='0' and fzpjh0=3859388 715 16:53:07 SQL Data In: ORACLE - Rows affected = 1 716 16:53:07 SQL Prepare: ORACLE - commit 717 16:53:07 SQL Execute: ORACLE - commit 718 16:53:07 SQL Data In: ORACLE - Rows affected = 0 719 16:53:17 SQL Prepare: ORACLE - RollBack 720 16:53:17 SQL Execute: ORACLE - RollBack 721 16:53:17 SQL Data In: ORACLE - Rows affected = 0