ROWNUM only available in ORACLE LEVEL1 dialect

  Explanation:  You have used ROWNUM outside of the ORACLE LEVEL1
  dialect.

  User Action:  Set your dialect to ORACLE LEVEL1 and re-issue the
  query.