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; /