procedure中调用另外一个有返回值的procedure

create or replace PROCEDURE get_total
(
skuprice out number
)
IS
price number;
BEGIN
  get_sku_price('12345',price);
  skuprice := price;
  DBMS_OUTPUT.PUT_LINE('skuprice = ' || skuprice);
END;

 

 

create or replace PROCEDURE get_sku_price
(sku varchar2,
price out number
)
IS
BEGIN
  price := 100;
END;