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

时间:2015-06-10 17:23:20   收藏:0   阅读:1456

1、错误描述

16:27:36	call 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;


原文:http://blog.csdn.net/you23hai45/article/details/46443527

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!