ibatis中分页说缺少右括号ORA-00907错误，各位大哥帮忙解决下

Question

 SELECT
* 
FROM
(
SELECT
*
FROM
(
SELECT
  m1.member_id,
  m1.member_name,
  DECODE(m1.member_type, 1, '托管业务', 2, '保理业务', 3, '金融租赁', 4, '银行卡同业'),
TO_CHAR(setup_date, 'YYYY/MM/DD'),
rownum r
FROM
MEMBER m1
            
WHERE
m1.member_type = 1
 <isNotEmpty property="spara1">
AND member_name LIKE #spara1#
</isNotEmpty>
)
WHERE
rownum &lt;= (currPage * pageSize)
 <isNotEmpty prepend="AND" property="spara1">
  (member_name like #member_name#)
  </isNotEmpty> 

) m1
WHERE
r > ((currPage-1) * pageSize + 1)   
        

Answer 1

ORACLE中没问题在java中用ibatis就有问题了