검색 sql 만드는중인데 계속 저렇게 오라클에러가 납니다.. 무엇이 문제일까요...

 

 String sql = " select * from (select rownum rnum, a.* from "
             + " ((select COST.ID_COST,COST.COST_DATE,TRANSACTION.TRANSACTION_NAME,COST.ID_EMPLOYEE,CATEGORY.CATEGORY_NAME, "
                  + " COST.COST_CONTENT,COST.COST_AMOUNT,PAYMENT.PAYMENT_NAME,PROJECT.PROJECT_NAME, "
                  + " COST.COST_NOTE from cost,transaction,category,payment,project "
                  + " where cost.id_transaction=transaction.id_transaction like '%" +  search_input  + "%' "
                  + " OR cost.cost_content like '%" + search_input + "%'"
                  + " OR TO_DATE(cost.cost_date,'YYYY-MM-DD') like '%" + search_input + "%'"
                  + " OR cost.id_category=category.id_category like '%" + search_input + "%' "
                  + " OR cost.id_payment=payment.id_payment like '%" + search_input + "%' "
                  + " OR cost.id_project=project.id_project like '%" + search_input + "%' order by cost.cost_date desc) a)) "
                  + " where "
                  + "(rnum >=? and rnum <=?)"
                  + " order by rnum asc";