日期:2014-05-17  浏览次数:20720 次

reports二次开发一条语句实在看不出有何错误
ebs 11.0.3 reports二次开发,一条语句实在看不出有何错误
  select count(*) into or_num from (
  select * from BOM.BOM_OPERATIONAL_ROUTINGS BOR
  ,BOM.BOM_OPERATION_SEQUENCES BOS where bor.assembly_item_id=65634 
  and bor.alternate_routing_designator is null
  and bor.routing_sequence_id=bos.routing_sequence_id
  AND BOS.DISABLE_DATE IS NULL
  );
reports developer报错:
Error 103 at line 155,column 45
  Encountered the symbol "(" when expecting one of the following:
  a PL/SQL variable or double-quoted string
  an expanded name
  an expanded name link
  a table reference expression
  a key word
  Resuming parse at line 161,column 20.
我把这条sql语句删除,reports developer就能通过编译,
哪位帮帮忙啊?????????????????????????

------解决方案--------------------
中文括号。
------解决方案--------------------
探讨
引用:
中文括号。

什么叫中文括号,应该怎么改这条sql语句

------解决方案--------------------
最好在某个编辑框内进行,然后,一次性把中文的转为英文