存储过程带返回参数

来源：互联网发布：网络攻防靶机的环境编辑：程序博客网时间：2024/05/16 07:22



IN 的是输入参数，out的是要输出的参数

===存储过程代码

BEGINDECLARE v_countGC int;DECLARE v_GCCountHold int;DECLARE v_GCIDHold int;DECLARE v_skuIDHold int;DECLARE v_onPlace varchar(50);select count(GCID),skuID,onPlace,GCCount,GCID into v_countGC,v_skuIDHold,v_onPlace,v_GCCountHold,v_GCIDHold from globalContainerwhere CBid = p_CBidHold;set r_GCCountHold = v_GCCountHold;set r_GCIDHold = v_GCIDHold;if v_countGC!=0 thenif v_onPlace = '' or v_onPlace is null thenif p_skuID = v_skuIDHold thenset v_useableBox = 2;elseset v_useableBox = 1;end if;elseset v_useableBox = 0;end if;elseset v_useableBox = 1;end if;select v_useableBox;END======调用该存储过程===========

CALL useableBox(v_CBidHold, v_skuID,v_useableBox,v_GCCountHold,v_GCIDHold);

定义三个变量：v_useableBox，v_GCCountHold，v_GCIDHold用于接收存储过程的输出参数

0 0