CREATE PROCEDURE innerproc(OUT param1 INT)BEGIN insert into sometable; SELECt LAST_INSERT_ID() into param1 ;END-----------------------------------CREATE PROCEDURE outerproc()BEGINCALL innerproc(@a);// @a gives you the result of innerprocSELECT @a INTO variableinouterproc FROM dual;END
OUT参数应该可以帮助您将值返回给调用过程。基于此，解决方案必须是这样的。
