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);
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。