#8
select count(1) as totalrow from (select t2.onenum,t2.allnum, t2.printstatus,t.apfd_code,t2.gidl_doc_numb, t2.orgid,t.bdgt_subj,t3.subjectcode,t3.subjectname, case when t.acst_id not in (887209,2001,3001,4001,5001,7001,8001,6066768) then decode(t2.fund_char,'0','預算內','1','其他財政性資金','2','其他','3','預算內(往年)','4','其他財政性資金(往年)','5','其他(往年)') else '其他' end as fund_char, t2.pay_amnt,t2.dtal_id,t2.item,t4.name,t.gath_org_name,t2.smry smry,t.acst_id from ga_t_apfd_bill t,sysmgr_org t1,ga_t_apfd_bill_dtal t2,busmgr_funnew t3,sysmgr_user t4 where 1=1 and t.gath_org_id = t1.orgid(+) and t.bdgt_subj=t3.subjectcode(+) and t.apfd_user_id=t4.userid(+) and t2.apfd_bill_id=t.apfd_bill_id and t.year=2012 and t3.year=2012 and t.ACST_ID=1001 and t.is_Del = 0 and t.status in ('4','5') and t2.gidl_doc_numb like %'414%' order by t1.orgcode,t.bdgt_subj, to_number(t.APFD_CODE))];nested exception is java.sql.SQLException: ORA-00911: 無效字符
誰知道這個哪兒錯了嗎