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:
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.
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.