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-08460: invalid environment clause in environment parameter

1 Answers  


QSM-02048: outer join in mv

1 Answers  


ORA-00050: operating system error occurred while obtaining an enqueue

1 Answers  


TNS-00236: Failed to initialize tracing

1 Answers  


NZE-29156: conditional RNG self-test failure

1 Answers  






ORA-09933: Deletion of old password file failed.

1 Answers  


LPX-00230: invalid character ~1u (~2x) found in a Name or Nmtoken

1 Answers  


RMAN-04011: recovery catalog database Password:

1 Answers  


ORA-32165: Cannot get XA environment

1 Answers  


ORA-32577: username must be SYS or SYSTEM

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


ORA-29845: indextype does not support local domain index on string partitioned table

1 Answers  


Categories