Q

Wrong number or types of argument in call

I am calling a stored procedure (named TASKS_DEF) through Java code. This procedure is called by passing 28 arguments. I get the error "PLS-00306 : wrong number or types of argument in call to 'TASKS_DEF'."

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.
This was first published in November 2006
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close