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就能通过编译,
哪位帮帮忙啊?????????????????????????
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就能通过编译,
哪位帮帮忙啊?????????????????????????
解决方案 »
- oracle 性能监控工具,sql工具(经典)
- Oracle创建表时生成同名表
- 请教下: ORACEL 中,使用select 语句时, 如何将表中的各字段 按“|”分隔符分开 选择出出来。 謝了。
- 关于处理在动态SQL语句中数值类型变量/字段为空的问题
- 大量数据从sql server中导入到 oracle中的高效方法~!
- pb9+sqlserver2000转到oracle9i ,应该学习什么书,推荐本经典的。
- linux as4 下装ORACLE9I 9204 报错 帮忙看一下吧
- 求救触发器?急??????//
- 有两台服务器,分别安装两个不同的数据库ncdc和ncdz,现在在ncdc的库中写一个存储过程
- 请问.NET里面如何使用Oracle存储过程里面的自定义数据类型?
- mysql 的一个小问题 写个sql语句
- Oracle中Decode函数用法
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
) tb ;加个别名试试看看
INTO OR_NUM
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
觉着你可以把外面的那层查询拿掉