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

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.new_procedure; expected 2, got 10.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);