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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19017: Attributes can only be simple scalars

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-24171: creation properties are only for internal use

1 Answers  


ORA-24093: AQ agent string not granted privileges of database user string

1 Answers  


ORA-29834: REF datatype not supported with operators

1 Answers  






PLS-00460: REPEATABLE subprogram 'string' has to be RNDS, WNDS, RNPS, and WNPS

1 Answers  


ORA-38607: FI minimum and maximum itemset length not between [1, string]

1 Answers  


ORA-25446: duplicate column value for table alias: string, column: string

1 Answers  


NNL-00291: Statistic counters are next reset in string

1 Answers  


NZE-29118: Cannot create PKCS #12 attributes.

1 Answers  


AMD-00136: Generation of SQL script "string" failed

1 Answers  


ORA-01288: file string is from a different database incarnation

1 Answers  


Categories