Encountered the symbol 'ORDER' when expecting one of following in Report

今天在捞取资料的时候用到rownum来建立一个新的view来存放自己想要的资料，在PL/SQL是可以的，Clause:

select DEPRN_RESERVE
  /*into ls_deprn*/
  from (select rownum as i, v.*
          from (select fds.DEPRN_RESERVE,fds.deprn_run_date
                  FROM fa_deprn_summary fds
                 where fds.asset_id =  &p_asset_id
                 order by fds.deprn_run_date desc) v) a
 where a.i = 2;

但是我要将此资料用在report中的Formula，就出现了如下的错误：

Error: Encountered the symbol 'ORDER' when expecting one of following

我查了好久的资料终于找到了解决方法，if your query work well on pl/sql,but in report there is a error

the problem can be due to the difference between the  pl/sq enginel in report and the engine used in the server,if so ,you can create a function/procedure in DB and calling it from report  passing the approriate parameters.

at last ,the problem is solved.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10673642/viewspace-538092/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10673642/viewspace-538092/