aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00306: wrong number or types of arguments in call to 'string'

PLS-00306: wrong number or types of arguments in call to 'string'
Cause: This error occurs when the named subprogram call cannot be matched to any declaration for that subprogram name. The subprogram name might be misspelled, a parameter might have the wrong datatype, the declaration might be faulty, or the declaration might be placed incorrectly in the block structure. For example, this error occurs if the built-in square root function SQRT is called with a misspelled name or with a parameter of the wrong datatype.
Action: Check the spelling and declaration of the subprogram name. Also confirm that its call is correct, its parameters are of the right datatype, and, if it is not a built-in function, that its declaration is placed correctly in the block structure.

请先 登录 后评论

1 个回答

小智
PLS-00306:调用“ string ” 中的错误数量或参数类型,
.原因:当命名的子程序调用不能与该子程序名称的任何声明匹配时,会发生此错误。子程序名称可能拼写错误,参数可能具有错误的数据类型,声明可能有问题,或声明可能在块结构中不正确地放置。例如,如果使用拼写错误的名称或参数为错误的数据类型调用内置平方根函数SQRT,则会发生此错误。,
.操作:检查子程序名称的拼写和声明。还要确认它的调用是正确的,它的参数是正确的数据类型,如果它不是内置函数,它的声明被正确地放在块结构中。,
.
请先 登录 后评论