Re: PLS-00306: wrong number or types of arguments in call

Hi Zahir,
It could be that you are binding the parameters of object refering
Stored Procedure without check whether parameter have already been
bounded to object or not. If parameter are already bounded then you
need to remove the existing binding before your new binding.

If you do not remove existing binding then you obviously will get the
error that "Wrong number of argument supplied" because if orginally
your procedure expects 2 parameter and you are rebinding the parameters
to command object then it will become 4 which indeed oracle will not
accept.

Hope this helps!

cheers!
Manpreet Khurana
Pial wrote:
> Hi:
>
> I am facing the problem while entering data: I am using C# parameters
> to PL/SQL functon.....
>
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to '....'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> Thanks in Advance
> Zahir

.

Relevant Pages

  • Re: PLS-00306: wrong number or types of arguments in call
    ... Hi Zahir, ... It could be that you are binding the parameters of object refering ... Stored Procedure without check whether parameter have already been ... > to PL/SQL functon..... ...
    (microsoft.public.dotnet.faqs)
  • Re: SQLDataAdapter.Update not working
    ... >> binding the dataset to the form? ... >> I have a stored procedure with two parameters, I set the values of the ... >> Then I call the update command ... >> Everything seems to work okay, however when I refresh the dataset the ...
    (microsoft.public.dotnet.framework.adonet)
  • SQLDataAdapter.Update not working
    ... Is it possible to update a database via stored procedure without data ... binding the dataset to the form? ... I have a stored procedure with two parameters, I set the values of the ... Everything seems to work okay, however when I refresh the dataset the ...
    (microsoft.public.dotnet.framework.adonet)
Loading