Store Procedure total parameters

[SALIH]

Dear All
is there any limit in store procedure for the number of parameters
you can pass.
I am calling the store procedure in SQL 2000 from vb.net code
which has got about 23 parameters.
But is generate an error like this;
e.Message "Too many arguments were supplied for procedure NewQuantTest." String

Please can you advise me what is the problem, I cannot see it.
Many Thanks for any reply
salih

[Edneeis]

If there is a limit it is more than 23, but it seems that you are passing too many parameters to the stored procedure. So if the procedure itself only has 10 and you are passing 11. Or possibly not passing them correctly.

[hellswraith]

Yes, double check what your passing the stored proceedure, and what the stored proceedure expects. I had a stored proceedure that took in 18 values, and I kept getting it wrong because I was shorting it one value every time I was trying to call it.