03-Parameter-Out.txt

create or replace procedure PRODUCT_SALESPRICE_AVERAGE_OUT
(P_CATEGORYID IN NUMBER,
O_SALESPRICE_AVERAGE OUT NUMBER)
is
begin
 select avg(SALESPRICE) into O_SALESPRICE_AVERAGE from PRODUCT where CATEGORYID=P_CATEGORYID;
end;




declare 

  V_SALESPRICE_AVERAGE number;

begin


  PRODUCT_SALESPRICE_AVERAGE_OUT(2,V_SALESPRICE_AVERAGE );

  dbms_output.put_line(V_SALESPRICE_AVERAGE);

end;