Error Code 1318 Incorrect number of arguments for PROCEDUR

               

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

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);

           

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow