declare
  -- SELECT returns many rows, single row syntax

  -- static SQL
  -- OK at 9.0.1
  v_avg_hire_date employees.hire_date%type := '25-JUN-97';
  v_emprec employees%rowtype;
  cursor cur is

    select * from employees where hire_date >= v_avg_hire_date;
   v_limit natural := 10;
begin
  open cur;
  loop
    fetch cur into v_emprec; exit when cur%notfound or cur%rowcount > v_limit;

    Emp_Util.Show_One (v_emprec);
  end loop;
end;
/
-- PL/SQL procedure successfully completed.