调用mysql存储过程时报错
OUT or INOUT argument 6 for routine mot1.P_SYS_PROCEDURE is not a
variable or NEW pseudo-variable in BEFORE trigger
原因:在调用时out参数没有加@符号
DROP PROCEDURE IF EXISTS `P_SYS_PROCEDURE`;
CREATE PROCEDURE `P_SYS_PROCEDURE`(in v_pro_id varchar(200),in v_pro_type varchar(20),in v_cycle varchar(20),in v_channel int,in v_tag int,out v_execcycle varchar(20),out v_result_tag char)
调用方法应该为
call P_SYS_PROCEDURE('mysql','1','20211022',99,0,@'1',@'N')