Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
来源:互联网 发布:中国知乎 编辑:程序博客网 时间:2024/06/04 18:19
1、错误描述
20:27:34call new_procedure(20150112)Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got 10.000 sec
1 queries executed, 0 success, 1 errors, 0 warnings查询:call query_student()错误代码: 1318Incorrect number of arguments for PROCEDURE test.query_student; expected 1, got 0执行耗时 : 0 sec传送时间 : 0 sec总耗时 : 0 sec
2、错误原因
CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`(in `departId` int,out `num` int)BEGIN select count(t.depart_name) into num from t_department_info t where t.depart_id = departId; END
call new_procedure(20150112);
在调用存储过程中,需要传入两个参数,但是只传了一个参数
3、解决办法
call new_procedure(20150112,@num);
1 0
- Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
- Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got
- 1318:Incorrect number of arguments for PROCEDURE worker.wage_alterdata; expected 7, got 6 [ SQL语句 ]
- Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW
- java.lang.IllegalArgumentException: Wrong number of arguments; expected 0, got 1
- wrong number of arguments (1 for 2)
- RampDiffuse纠错——Error:incorrect number of arguments to numeric-type constructor
- Error: expected expression, got '}'
- Yii2 swiftmailer Expected response code 220 but got code "502", with message "502 Error:
- inconsistent datatypes: expected DATE got NUMBER
- wrong number of arguments
- django运行错误:wrong number of arguments for 'set' command
- ERR wrong number of arguments for 'sadd' command
- Expected response code 220 but got code “”, with message “””
- Expected response code 220 but got code “”, with message “””
- In company code XX, the number range 01 is missing for the year XXXX
- Incorrect number of FETCH variables
- error: macro "min" passed 3 arguments, but takes just 2 error: expected ‘)’ before ‘const’ 解决方法
- C++中类的多态与虚函数的使用
- Java程序员的6个级别
- 快速幂取余
- android 布局文件的权重问题
- SqlServer 2012 FileTable 文件表
- Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
- C#获取CSV文件内容对逗号和引号分隔的处理
- scala 函数学习
- 表中含有重复键,连接会产生很大的记录
- Android的GridView和ScrollView的嵌套
- zerglurker的C语言教程004——指针初步讲解
- UVA 10891 Game of Sum 区间dp
- Netty-一个简单的服务器
- 软件测试人员的修行新篇