ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Encountered the symbol 'ORDER' when expecting one of following in Report

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

原创 Linux操作系统 作者:rena_zhang 时间:2009-01-13 21:20:24 0 删除 编辑

今天在捞取资料的时候用到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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: FA Physical inventory
下一篇: Oracle Asset
请登录后发表评论 登录
全部评论

注册时间:2008-07-02

  • 博文量
    11
  • 访问量
    16054