Ask the Expert

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.

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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: