Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got
来源:互联网 发布:usda数据查询 编辑:程序博客网 时间:2024/05/16 13:45
1、错误描述
13:58:20call new_procedure('2000','zhangsan')Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got 20.000 sec
2、错误原因
CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()BEGIN set @a=101; while @a<2000 do set @b = rand_string(10); set @c=1; insert into example1 values(@a,@b,@c); set @a=@a+1; if(@a%2=0) then set @c=0; end if; end while;END该存储过程没有用到参数,故调用时不需要加参数
3、解决办法
call new_procedure;
1 0
- Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got
- Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
- 1318:Incorrect number of arguments for PROCEDURE worker.wage_alterdata; expected 7, got 6 [ SQL语句 ]
- java.lang.IllegalArgumentException: Wrong number of arguments; expected 0, got 1
- RampDiffuse纠错——Error:incorrect number of arguments to numeric-type constructor
- Error: expected expression, got '}'
- wrong number of arguments (1 for 2)
- Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW
- 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 “””
- Incorrect number of FETCH variables
- syntax error; found ` ; ' expecting ` )' 和Error TCC: insufficient number of arguments to `IIC_RegRead'
- ORA-00932: inconsistent datatypes: expected NUMBER got CHAR
- VS MFC获取文件路径
- 第八周项目一 运算符重载
- 智力题
- C Primer Plus 第七章程序清单……2014.4.24
- 基于Jenkins+git+gradle的android持续集成
- Error Code: 1318. Incorrect number of arguments for PROCEDURE student.new_procedure; expected 0, got
- 结构体成员的内存分布以及大端小端
- java 跳出当前for循环
- linux 静态IP配置
- 1008. 数组元素循环右移问题
- 函数
- LeetCode Maximum Subarray DP
- 问题:java Swing 文件管理
- hibernate重要查询语句