Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW，veriloginout

Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW，veriloginout

1、錯誤描述

16:27:36call new_procedure(20150112,1)Error Code: 1414. OUT or INOUT argument 2 for routine company.new_procedure is not a variable or NEW pseudo-variable in BEFORE trigger0.063 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,1);

3、解決辦法

call new_procedure(20150112,@depart_id);

    out參數是資料庫表中的欄位

select @depart_id as depart_id_out;