1 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 2 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 3 09:40:02 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 4 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 5 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 6 09:40:02 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 7 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 8 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 9 09:40:02 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 10 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 11 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 12 09:40:02 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 13 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 14 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 15 09:40:02 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 16 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 17 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 18 09:40:02 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 19 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 20 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 21 09:40:02 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 22 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 23 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 24 09:40:02 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 25 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 26 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 27 09:40:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 28 09:40:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 29 09:40:02 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 30 09:40:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 31 09:40:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31.000000 32 09:40:02 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 33 09:40:03 SQL Execute: ORACLE - select BMMC00, (select to_char(round(sum(KJYWPZ)/greatest(count(1),1),2)) from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00 and a.KJYWPZ>0) RJKJPZ, (select to_char(round(sum(KJYWJE)/greatest(count(1),1),2)) from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00 and a.KJYWPZ>0) RJKJFY, (select round(sum(sign(KJYWPZ))/greatest(count(1),1),4)*100||'%' from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) SYKJBL, (select ROUND((Select Sum(ROUND(YPZSL0*ZHL000/DDD000,3)) from VW_YK_KSSJB0_ZY a where a.BQBMBH=m.BMBH00 and a.FYRQ00 between '20121127' and '20121127')/ (select greatest(count(*),1) from ZY_ZYBRMX a where ZYRQ00 between '20121127' and '20121127' and a.BQH000=m.BMBH00 and FLAG00='0'),2)*100 from dual) KJSYQD, (select rtrim(replace(to_char(round(sum(KJYWJE)/greatest(sum(YPF000),1),4)*100,'FM9999990.999')||' ','. ',''))||'%' SJ0000 from ZH_CYBRBB a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) KJYWBL, (select round(sum(sign(EJKJPZ))/greatest(count(1),1),4)*100||'%' from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) EJKJBL, (select ROUND((Select Sum(ROUND(YPZSL0*ZHL000/DDD000,3)) from VW_YK_KSSJB0_ZY a where a.BQBMBH=m.BMBH00 and a.FYRQ00 between '20121127' and '20121127' and KSSJB0=2)/ (select greatest(count(*),1) from ZY_ZYBRMX a where ZYRQ00 between '20121127' and '20121127' and a.BQH000=m.BMBH00 and FLAG00='0'),2)*100 from dual) EJKJQD, (select rtrim(replace(to_char(round(sum(EJKJJE)/greatest(sum(YPF000),1),4)*100,'FM9999990.999')||' ','. ',''))||'%' SJ0000 from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) EJYWBL, (select round(sum(sign(SJKJPZ))/greatest(count(1),1),4)*100||'%' from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) SJKJBL, (select ROUND((Select Sum(ROUND(YPZSL0*ZHL000/DDD000,3)) from VW_YK_KSSJB0_ZY a where a.BQBMBH=m.BMBH00 and a.FYRQ00 between '20121127' and '20121127' and KSSJB0=3)/ (select greatest(count(*),1) from ZY_ZYBRMX a where ZYRQ00 between '20121127' and '20121127' and a.BQH000=m.BMBH00 and FLAG00='0'),2)*100 from dual) SJKJQD, (select rtrim(replace(to_char(round(sum(SJKJJE)/greatest(sum(YPF000),1),4)*100,'FM9999990.999')||' ','. ',''))||'%' SJ0000 from ZH_CYBRBB_LS a where a.CYRQ00 between '20121127' and '20121127' and a.CYBQ00=m.BMBH00) SJYWBL from BM_BMBM00 m where bmxz00='9' and czbz00<>'2' order by PXXH00,BH0000 34 09:40:03 SQL Error: ORACLE - ORA-01722: ÎÞЧÊý×Ö 35 09:40:03 SQL Error: ORACLE - Unmapped SQL Error Code: 1722 36 09:40:03 SQL Data In: ORACLE - Rows affected = 0