欢迎投稿

今日深度:

Error Code: 1318. Incorrect number of arguments for PROCEDUR

Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got,errorexpected


1、错误描述

20:27:34	call new_procedure(20150112)	Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got 1	0.000 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);

www.htsjk.Com true http://www.htsjk.com/shujukunews/8646.html NewsArticle Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got,errorexpected 1、错误描述 20:27:34call new_procedure(20150112)Error Code: 1318. Incorrect number of arguments for PROCEDURE company....
评论暂时关闭