MySQL 存储过程相互调用举例

create procedure prccharges(in orderno char(6),out shippingCharges float(4,2),out wrapCharges float(4,2))
   begin
    select mshippingcharges into shippingCharges from orders where corderno = orderno;
    select mgiftwrapcharges into wrapcharges from orders where corderno = orderno;
   end;
create procedure prcHandLingCharges(in orderno char(6),out handlingCharges float(4,2))
   begin
    declare ppp float(4,2);
    declare qqq float(4,2);
    call prccharges(no,p,q); 
    set handlingCharges = p+ q;
   end;

上面的例子调用方法

call prcHandLingCharges('1',@af);
select @af;