Click here to Skip to main content
15,901,035 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
while executing the stored procedure it is showing the following error message even though the passing arguments are matching with the arguments in stored procedure.

"Procedure or function usp_MemberRegistration_UPDATE_BY_MemberRegID_MEMBERPROFILE has too many arguments specified".
Posted
Updated 6-Sep-11 0:40am
v2

This error will occur only when the passing arguments are not matching with the arguments in stored procedure. So, check one more time or share your code with us.
 
Share this answer
 
v2
Comments
Wendelius 6-Sep-11 6:52am    
That's it, my 5
Without your code it is difficult to tell exactly, but: do you execute the SP in a loop? If so, do you add parameters withing the loop? That can cause the problem: move the parameter add outside the loop and just change the values, or create a new SqlCommand object each time round the loop.
 
Share this answer
 
Comments
Wendelius 6-Sep-11 6:53am    
Good answer, just a case like that was yesterday. my 5
OriginalGriff 6-Sep-11 7:23am    
I remembered that one - that gave me the clue! The error message was the same IIRC
Its tough to say anything without looking at your code.
Still you can check the number of parameters in the stored proc and the method from where you are sending them should be same and also check the order of the parameters.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900