create or replace function max_item_price(myFood in goods.food%type)
  return goods.price%type  as

  answer goods.price%type; 

 cursor mPrice(foodType in goods.flavor%type)
        is select max(price) from goods where flavor = foodType;

begin
  
   open mPrice(myFood);
   fetch mPrice into answer;

    return (answer);

end;
/
