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就能通过编译,
哪位帮帮忙啊?????????????????????????
------解决方案--------------------
中文括号。
------解决方案--------------------
------解决方案--------------------
最好在某个编辑框内进行,然后,一次性把中文的转为英文