Error Code: 1318. Incorrect number of arguments for PROCEDUR

1、错误描述

20:27:34call new_procedure(20150112)Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got 10.000 sec2、错误原因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;ENDcall new_procedure(20150112);

在调用存储过程中,需要传入两个参数,,但是只传了一个参数

3、解决办法

call new_procedure(20150112,@num);

就看你能不能战胜它。战胜了,你就是英雄,就是生活的强者。

Error Code: 1318. Incorrect number of arguments for PROCEDUR

相关文章:

你感兴趣的文章:

标签云: