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

have you checked your arguments to see if they are the correct type and
correct number? this is what the error message indicates

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc
[quoted text, click to view]

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


[quoted text, click to view]