关于Ibatis ORA-00907: missing right parenthesis

Ibatis 一直报ORA-00907: missing right parenthesis的错误，找了很久

<![CDATA[   
       select *
          from (select rownum rm,D.* from
            (
                select A.ID,
                A.LOTTERY_ID,
                A.PERIOD_CODE,
                A.OTHER_PAY,
                A.REMARK,
                A.ORDER_HANDLER
                from LOTTERY_ORDER A
                <dynamic prepend="where">
                    <isNotNull prepend=" AND " property="userId">
                       A.USER_ID = #userId#
                    </isNotNull>
                    <isNotNull prepend=" AND " property="lotteryId">
                       A.LOTTERY_ID = #lotteryId#
                    </isNotNull>
                </dynamic>
                order by A.ORDER_DATE desc
            ) D
    where rownum <= #endNum#
         )
     where rm > #startNum# 

  ]]>  

后来将<![CDATA[     ]]> 标签移到下面 改成这样 

  where rownum <![CDATA[ <= ]]>  #endNum#

就OK了。