Sample Header Ad - 728x90

PLS-00306 Error: How to find the wrong argument?

14 votes
2 answers
115172 views
**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. How do I quickly identify the wrong argument? I have a stored-procedure with dozens of parameters. Is there an easy way to check the differences between the used and defined procedure? I don't want to check it line by line..
Asked by Stephan Schielke (243 rep)
Sep 23, 2011, 09:44 AM
Last activity: May 23, 2024, 05:30 PM