sql>create or replace procedure p_gen_months
  2    (p_start in date, p_end in date, p_rc out sys_refcursor)
  3  is
  4  begin
  5    open p_rc for
  6      select to_char(add_months(trunc(p_start, 'mm'), rownum - 1), 'Monyyyy') dt
  7        from all_objects
  8       where rownum <= months_between(trunc(p_end, 'mm'), trunc(p_start, 'mm')) + 1;
  9  end;
 10  /
 
Procedure created.
 
sql>var rc refcursor
sql>exec p_gen_months(to_date('11/01/2004', 'mm/dd/yyyy'), to_date('02/01/2005', 'mm/dd/yyyy'), :rc)
 
PL/SQL procedure successfully completed.
 
sql>print rc
 
DT
-------
Nov2004
Dec2004
Jan2005
Feb2005
 
4 rows selected.