Votes

Show us which are the "wrong number or types of arguments" (details)
 
Dear Bryn,

I love the flexibility in PL/SQL for defining and calling programs: I can overload, pass arguments with named notation, rely on default argument values, etc.

I would love it even more, though, if you could give us more information about the cause of the problem when I get the "PLS-00306: wrong number or types of arguments in call to 'ABC'" error!


If we call a program and there is a mismatch on the number of arguments, or the types of arguments, we see this compile error:

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

Unfortunately, the compiler does not give us any clues as to the source of the difficulty and this can be very difficult to track down.


Please give us more detailed information about the situation that caused the error.

** Which argument has the wrong type?

** Do we have too few or too many arguments in the list?


Steven Feuerstein, PL/SQL Evangelist, Quest Software: "Help me help Oracle improve the PL/SQL language!"


Bryn Llewellyn: "We love to hear from PL/SQL developers. Let us know what is important to you!"

PL/SQL Obsession
Apex Evangelists
O'Reilly Books on Oracle
OTN PL/SQL Best Practices
OTN PL/SQL Page
Steven Feuerstein's Blog