mysql调用存储过程报错返回

SqlSugar 老数据

 1  2336

悬赏：5 飞吻

存错过程：

CREATE DEFINER = 'root'@'localhost'

PROCEDURE test.sp_school(IN `@p1` INT, OUT `@p2` INT)

BEGIN

set @p2 = 10;

END

代码：

var p11 = new SugarParameter("@p1", "1");

var p22 = new SugarParameter("@p2", null, true);//isOutput=true

var dt2 = Db.Ado.UseStoredProcedure().GetDataTable("sp_school", p11, p22);

异常信息：OUT or INOUT argument 2 for routine test.sp_school is not a variable or NEW pseudo-variable in BEFORE trigger

热忱回答（1）