为过程或函数指定了过多的参数
总结刚结束的机房合作只有一种感觉那就是：好多好多东西自己都不会，又有好多东西在这次合作中学到了，总之就是痛并快乐着！ 接下来就谈谈在退卡时调用存储过程PROC_ReturnCard时出现错误及解决过程。图如下： 刚开始的时候就考虑到D层的参数是不是写的过多
总结刚结束的机房合作只有一种感觉那就是：“好多好多东西自己都不会，又有好多东西在这次合作中学到了，总之就是痛并快乐着！”
接下来就谈谈在退卡时调用存储过程PROC_ReturnCard时出现错误及解决过程。图如下：
刚开始的时候就考虑到D层的参数是不是写的过多了，于是在数据库中查几遍参数都一样啊！为什么就是不行呢？于是上网查了下：有以下几种情况
一、如果你的参数添加是在循环体内完成第2次时就会重复添加，此时触发参数过多异常
解决方法1，参数在循环体外添加，for内部只赋值和取返回值
解决方法2，每次循环清空参数Parameters.Clear();
二、普通调用
1、存储过程调用错了（一般是存储过程名字字母错误）。
2、用户创建的存储过程与系统存储过程同名。如果以sp开头，用户创建的存储过程，总会先检查master数据库（即使该存储过程已用数据库名称限定）。 如果用户创建的存储过程与系统存储过程同名，则永远不执行用户创建的存储过程 ，因此自定义存储过程不要与系统存储过程同名
3、超过指定的参数。以上情况你的代码中均没有出现，目前最大的可能性是你连接的数据库中存储过程中的参数确实没有那么多，而你改的是另一个数据库中的存储过程！
4、清空参数Parameters.Clear();
由于我的属于第二种情况经过以上的排查感觉，第一种存储过程名称写错绝对不可能（自我感觉良好）第二种也排除，因为我严格按命名规范来的。第三种情况已经查过好多次数据库了没错啊！因此就开始找第四中的解决办法，结果还是不行。只好找人帮忙他在程序运行时，突然发现我调用的存储过程的名字不对，这时我立刻晕死！明明是PROC_ReturnOut 而我却写成了PROC_SelectCheckOut这么低级的错误，竟然让我忙活了一下午。更不可原谅的是自己就没有检查却肯定这是对的，没有验证就下结论，这定是死罪！
因此通过这个小小的错误，必须得做自我反思，今后在做事情的时候千万不要以“我认为、、、”来下定论。一定要经过实际排查不放过任何细节，不能凭空想象，只有做过了才有资格发表评论。就让我们以小见大来看待这个问题并做出反思！
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Tips for dynamically creating new functions in golang functions
Apr 25, 2024 pm 02:39 PM
Go language provides two dynamic function creation technologies: closure and reflection. closures allow access to variables within the closure scope, and reflection can create new functions using the FuncOf function. These technologies are useful in customizing HTTP routers, implementing highly customizable systems, and building pluggable components.
Considerations for parameter order in C++ function naming
Apr 24, 2024 pm 04:21 PM
In C++ function naming, it is crucial to consider parameter order to improve readability, reduce errors, and facilitate refactoring. Common parameter order conventions include: action-object, object-action, semantic meaning, and standard library compliance. The optimal order depends on the purpose of the function, parameter types, potential confusion, and language conventions.
How to write efficient and maintainable functions in Java?
Apr 24, 2024 am 11:33 AM
The key to writing efficient and maintainable Java functions is: keep it simple. Use meaningful naming. Handle special situations. Use appropriate visibility.
Complete collection of excel function formulas
May 07, 2024 pm 12:04 PM
1. The SUM function is used to sum the numbers in a column or a group of cells, for example: =SUM(A1:J10). 2. The AVERAGE function is used to calculate the average of the numbers in a column or a group of cells, for example: =AVERAGE(A1:A10). 3. COUNT function, used to count the number of numbers or text in a column or a group of cells, for example: =COUNT(A1:A10) 4. IF function, used to make logical judgments based on specified conditions and return the corresponding result.
Comparison of the advantages and disadvantages of C++ function default parameters and variable parameters
Apr 21, 2024 am 10:21 AM
The advantages of default parameters in C++ functions include simplifying calls, enhancing readability, and avoiding errors. The disadvantages are limited flexibility and naming restrictions. Advantages of variadic parameters include unlimited flexibility and dynamic binding. Disadvantages include greater complexity, implicit type conversions, and difficulty in debugging.
C++ Function Exception Advanced: Customized Error Handling
May 01, 2024 pm 06:39 PM
Exception handling in C++ can be enhanced through custom exception classes that provide specific error messages, contextual information, and perform custom actions based on the error type. Define an exception class inherited from std::exception to provide specific error information. Use the throw keyword to throw a custom exception. Use dynamic_cast in a try-catch block to convert the caught exception to a custom exception type. In the actual case, the open_file function throws a FileNotFoundException exception. Catching and handling the exception can provide a more specific error message.
What is the difference between custom PHP functions and predefined functions?
Apr 22, 2024 pm 02:21 PM
The difference between custom PHP functions and predefined functions is: Scope: Custom functions are limited to the scope of their definition, while predefined functions are accessible throughout the script. How to define: Custom functions are defined using the function keyword, while predefined functions are defined by the PHP kernel. Parameter passing: Custom functions receive parameters, while predefined functions may not require parameters. Extensibility: Custom functions can be created as needed, while predefined functions are built-in and cannot be modified.
Advanced usage of reference parameters and pointer parameters in C++ functions
Apr 21, 2024 am 09:39 AM
Reference parameters in C++ functions (essentially variable aliases, modifying the reference modifies the original variable) and pointer parameters (storing the memory address of the original variable, modifying the variable by dereferencing the pointer) have different usages when passing and modifying variables. Reference parameters are often used to modify original variables (especially large structures) to avoid copy overhead when passed to constructors or assignment operators. Pointer parameters are used to flexibly point to memory locations, implement dynamic data structures, or pass null pointers to represent optional parameters.
