存储过程没有任何参数时出错

时间:2022-03-09 22:51:41

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

我试图使用亚音速调用存储过程并且未设置对象引用。它正在为其他程序工作。只有在程序没有任何参数时才会失败。

Is this a known error? Is there a fix?

这是一个已知错误吗?有修复吗?

(I am using the latest version)

(我使用的是最新版本)

3 个解决方案

#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.

这是一个已知问题,此时的解决方法是为存储过程创建一个不执行任何操作的参数,我喜欢使用int并传递0。

This should hopefully be fixed by v3.0.

希望这可以通过v3.0修复。

#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).

这已在版本2.2中修复(我现在无法追踪Google Code或CodePlex问题,但我确定它已修复)。

#3


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

升级到修复此问题的最新版本:在此处获取2.2版本

#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.

这是一个已知问题,此时的解决方法是为存储过程创建一个不执行任何操作的参数,我喜欢使用int并传递0。

This should hopefully be fixed by v3.0.

希望这可以通过v3.0修复。

#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).

这已在版本2.2中修复(我现在无法追踪Google Code或CodePlex问题,但我确定它已修复)。

#3


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

升级到修复此问题的最新版本:在此处获取2.2版本