今天使用toad的schema查看一些function,procedure,发现在10g2下报错.
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
5 rows selected.
有些能够打开编辑显示,有些提示出错.一般提示:
'IN' is not a valid integer value
使用SQLMonitor跟踪程序,发现基本上出错前都是执行这个sql语句:
SELECT *
FROM all_arguments
WHERE object_id = (
SELECT object_id
FROM all_objects
WHERE owner = :OWNER
AND object_name = :Proc
AND object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION'))
order by Object_Name, Overload, Sequence
对比all_arguments视图发现,问题在10g2中增加了一个字段SUBPROGRAM_ID,
也许就是这个原因导致toad程序出错.
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
5 rows selected.
有些能够打开编辑显示,有些提示出错.一般提示:
'IN' is not a valid integer value
使用SQLMonitor跟踪程序,发现基本上出错前都是执行这个sql语句:
SELECT *
FROM all_arguments
WHERE object_id = (
SELECT object_id
FROM all_objects
WHERE owner = :OWNER
AND object_name = :Proc
AND object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION'))
order by Object_Name, Overload, Sequence
对比all_arguments视图发现,问题在10g2中增加了一个字段SUBPROGRAM_ID,
也许就是这个原因导致toad程序出错.