1       10:45:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 648.000000
2       10:45:45  SQL Execute: ORACLE - select b.bqh000 from bm_bmbm00 a,bm_bqks00 b where a.bmbh00=b.ksh000 and a.bmbh00=? and rownum=1

3       10:45:45  SQL Execute: ORACLE - select BBMC00,BBID00 from BM_BBZD00

4       10:45:45  SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD
 where YXBZ00='Y'

5       10:45:45  SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

6       10:45:45  SQL Execute: ORACLE - select BMMC00 from BM_BMBM00 where BMBH00='648'

7       10:45:45  SQL Execute: ORACLE - select TRIM(VALUE0) from XT_XTCS00 where name00='JY_FJYTJKS_PRINT'

8       10:45:45  SQL Execute: ORACLE - select 1 from VW_JY_TJKS00 where bmbh00='648'

9       10:45:45  SQL Execute: ORACLE - select 1 from VW_JY_JYKS00 where bmbh00='648'

10      10:45:45  SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='756' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from (select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00 from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') 
 and A.PYRQ00 between '20120229' and '20120229' and ZYGHID in (SELECT ZYGHID FROM JY_YW0000 WHERE SQKS00 = '648' or A.SQBQ00 = '648')) t1 order by t1.PYRQ00 desc,t1.yqdh00,t1.ybh000,t1.ch0000 asc

11      10:45:45  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' 号:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='BC0001' and pyrq00='20120229' and rownum=1

12      10:45:45  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b,jy_yw0000 c where YBH000 = 'BC0001' and PYRQ00 = '20120229' and c.jyywid=b.jyywid

13      10:45:45  SQL Error: ORACLE - ORA-00918: 未明确定义列

14      10:45:45  SQL Error: ORACLE - Unmapped SQL Error Code: 918
15      10:45:45  SQL Data In: ORACLE - Rows affected = 0