Click here to Skip to main content
12,950,268 members (75,030 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I am using a stored procedure for insertion, updation, retrieval of data.
Sometimes it is showing unexpected errors. First it works smoothly, but I think I need to fix some settings.
It is showing errors like "Procedure or function declares too many arguments", "@Date is not supplied".
How can i solve it ?
Posted 19-Nov-12 2:50am
Darkjo 19-Nov-12 8:53am
In order to have more details, can you show us the procedure please?
__TR__ 19-Nov-12 8:55am
Looking at your error message it looks like the parameters you are passing from your code is not matching with the parameters in your stored procedure.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

First check number of parameter name and value is same or not.
Second check you provided parameter name (which you sending from your application at the time of calling sp), it must be same as SP parameter name (check you have provide @).

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,829
CHill60 3,460
Maciej Los 2,953
Jochen Arndt 1,975
ppolymorphe 1,820

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 19 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100