title: use oracle cursor within a sys_refcursor
body: <p>I've got a PL/SQL package that returns a sys_refcursor based on the id that you pass it.  I'd like to iterate through some ids and create a new ref cursor with one column from the original result set repeated for each id.  (Sort of a cross tab.)  A very simplified version of the PL/SQL block looks like:</p>
  
  <pre><code>create or replace package body dashboard_package is
  
     procedure visits(RC in out sys_refcursor, IdNumber varchar2) as 
     BEGIN
  
        OPEN RC FOR 
  
  
        select *
    from (
          select cat, cat_order, subcat, label_text
                 , trim(to_char(sum(v.current_month),'9,999,999,999')) current_month
                 , trim(to_char(sum(v.ly_month),'9,999,999,999')) ly_month
                 , trim(to_char(sum(v.ytd_tot),'9,999,999,999')) ytd_tot
                 , trim(to_char(sum(v.lytd_tot),'9,999,999,999')) lytd_tot
                 , trim(to_char(sum(v.ly_tot),'9,999,999,999')) ly_tot
            from dashboard v
           where v.id_number = IdNumber
           group by cat_order, subcat, cat, label_text
  
              union all
              ...
               ) a
  
       order by cat_order, subcat;
  
         END; 
  END;
  </code></pre>
  
  <p>I think if I had something like this</p>
  
  <pre><code>create or replace procedure test_refcur is
     refCursorValue SYS_REFCURSOR;   
  begin
     dashboard_package.visits(refCursorValue,12345);
     for cursrow in refCursorValue loop
        dbms_output.put_line(cursrow.ytd_tot);
     end loop;
  end test_refcur;
  </code></pre>
  
  <p>working, I could take it from there... any thoughts?  Or perhaps clarification on the question that I should be asking.</p>