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

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

Show quoteHide quote

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:
Show quoteHide quote

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:
Show quoteHide quote

long time transaction
DataGrid Row Auto-Size
Free Balloon tool tip for .NET apps
Dynamically Loading Assemblies in ASP.NET
Co-existance with VS 6?
unable find assebly folder in regedit for global assembly cache
Invalid Property Value Error
port 25
Pdf Requirements
Best way to create software documentation