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;