1       11:59:57  SQL Execute: ORACLE - select rownum RN, B.* from (  select A.*, decode(NL0000, 0, null, null, null, NL0000||NLDWMC) NLDW00, 
    trim(SF_PE_GetYXJG(A.TJH000)) YXJG00 
  from (
  select TJH000, XM0000, XBMC00, NL0000, NLDWMC, TTMC00, TTBM00, FZMC00, DJRQGG, JL0000, trim(ZS0000) ZS0000, trim(JY0000) JY0000, TTGH00, ZYBJL0,GZZGL0, JHGL00, ZJWC00, JA0000 
    from VW_PE_TJZ000 A where 1=1  and TTID00 = 1222 and RWID00 = 4912  and A.DJRQ00 between '20150624' and '20160624' 
  union 
  select TJH000, XM0000, XBMC00, NL0000, NLDWMC, TTMC00 ,TTBM00, FZMC00, DJRQGG, JL0000, trim(ZS0000) ZS0000, trim(JY0000) JY0000, TTGH00, ZYBJL0,GZZGL0, JHGL00, ZJWC00, JA0000 
    from VW_PE_TJZ000_ARCH A where 1=1  and TTID00 = 1222 and RWID00 = 4912  and A.DJRQ00 between '20150624' and '20160624' 
  order by TJH000 ASC ) A ) B where 1=1 

2       11:59:57  SQL Error: ORACLE - ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB

3       11:59:57  SQL Error: ORACLE - Unmapped SQL Error Code: 932
4       11:59:57  SQL Data In: ORACLE - Rows affected = 0
5       11:59:58  SQL Execute: ORACLE - select rownum RN, B.* from (  select A.*, decode(NL0000, 0, null, null, null, NL0000||NLDWMC) NLDW00, 
    trim(SF_PE_GetYXJG(A.TJH000)) YXJG00 
  from (
  select TJH000, XM0000, XBMC00, NL0000, NLDWMC, TTMC00, TTBM00, FZMC00, DJRQGG, JL0000, trim(ZS0000) ZS0000, trim(JY0000) JY0000, TTGH00, ZYBJL0,GZZGL0, JHGL00, ZJWC00, JA0000 
    from VW_PE_TJZ000 A where 1=1  and TTID00 = 1222 and RWID00 = 4912  and A.DJRQ00 between '20150624' and '20160624' 
  union 
  select TJH000, XM0000, XBMC00, NL0000, NLDWMC, TTMC00 ,TTBM00, FZMC00, DJRQGG, JL0000, trim(ZS0000) ZS0000, trim(JY0000) JY0000, TTGH00, ZYBJL0,GZZGL0, JHGL00, ZJWC00, JA0000 
    from VW_PE_TJZ000_ARCH A where 1=1  and TTID00 = 1222 and RWID00 = 4912  and A.DJRQ00 between '20150624' and '20160624' 
  order by TJH000 ASC ) A ) B where 1=1 

6       11:59:58  SQL Error: ORACLE - ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB

7       11:59:58  SQL Error: ORACLE - Unmapped SQL Error Code: 932
8       11:59:58  SQL Data In: ORACLE - Rows affected = 0