且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

为什么会收到此错误? ORA-06550 PLS-00306

更新时间:2022-12-03 13:51:45

如果您在谷歌(或任何其他ORA错误)中键入ORA-06550,您将得到解释。在这种情况下,没有多少帮助,因为它似乎是一般错误。我的猜测可能是因为你加了prm3两次(不确定):



If you type "ORA-06550" in google (or any other ORA error) you''ll get the explanation. In this case, not much of help as it seems to be a generic error. My guess is that it might be because you add prm3 twice (not sure though):

//btw is "paramters" a typ-o ?  
paramters.Add(prm3);
paramters.Add(prm3);





我会先尝试从数据库调用存储过程来检查是否存在工作,然后从代码中调用它。



PS:请确认您提供的代码与您使用的代码100%相同。在提供的代码中似乎有几种类型,这使得找到罪魁祸首更加困难。



希望这会有所帮助。



I would first try to call the Stored Procedure from the database to check if that works, then call it from code.

PS: Please verify that the code you provide here is 100% the same as the code you use. There seem to be several typ-o''s in the provided code, which makes it harder to find the culprit.

hope this helps.


问题在于objDataAccessUtilities.ExecuteDataReader(command);而不是这个我们必须使用

objDataAccessUtilities.ExecuteNonQuery(command);
The problem is with objDataAccessUtilities.ExecuteDataReader(command); instead of this we have to use
objDataAccessUtilities.ExecuteNonQuery(command);