使用TOAD(8.5.3)打开ORACLE10.2中存储过程报错,'IN' is not a valid integer value OR 'OUT' is not a valid integer value. 这种错误只针对那种有输入,输出参数设置的存储过程。如果无参数就没问题。 有遇到过或解决过这种问题的吗?是什么原因?如何解决?
使用TOAD(8.5.3)打开ORACLE10.2中存储过程报错,'IN' is not a valid integer value OR 'OUT' is not a valid integer value. 这种错误只针对那种有输入,输出参数设置的存储过程。如果无参数就没问题。 有遇到过或解决过这种问题的吗?是什么原因?如何解决?
,如下为官方自述
TOAD version 8.6.1 is provided as a patch with selected fixes to version 8.6. This patch version is not intended to address all reported issues. Rather, it addresses a subset of the issues, selected based on severity and complexity.In particular, the following problems are addressed:When Oracle patched version 10.2.0.1 with version 10.2.0.2 the structure of the ALL_ARGUMENTS view changed, causing Toad 8.6.0 or earlier to state: "IN" is not a valid integer value when selecting procedures in the Schema Browser or loading them into the Procedure Editor. Toad 8.6.1 remedies this problem.