I am calling a stored procedure (named TASKS_DEF) through Java code. This procedure is called by passing 28 arguments.
The error is like this:
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
PLS-00306 : wrong number or types of argument in call to 'TASKS_DEF'
ORA-06550 : line 1, colomn 7:
PL/SQL : statement ignored
The PLS-306 error is telling you one of two things. 1) You have not supplied the proper number of arguments required by the stored procedure. 2) The arguments do not match the correct datatypes. So start by ensuring you are specifying the parameters you must be specifying. And then ensure that you have the proper datatypes. For instance, if parameter 2 is a NUMBER datatype as defined in the stored procedure, you cannot pass "abcd" to parameter 2.