Error when the Stored procedure don't have any parameters

Question

Hi I am trying to call the stored procedure using subsonic and getting Object Reference not set. It is working for othe procedure only fails if the procedure don't have any parameters.

Is this known error? any fix?

Thanks

(I am using the latest version)

Answer 1

This is a known issue, the workaround at this time is to create a parameter for the stored procedure that doesn't do anything, I like to use an int and pass 0.

This should hopefully be fixed by v3.0.

Answer 2

This was fixed in version 2.2 (I can't track down the Google Code or CodePlex issue for it right now, but I'm certain it was fixed).

Answer 3

Upgrade to the latest version in which this is fixed: Get the 2.2 version here