title: PLS-00221: 'C1'(cursor) is not a procedure or is undefined
body: <p>I am creating a package to use with Jasper reports where I learnt that I need <code>SYS_REFCURSOR</code> but I cannot seem to be able to Loop my cursors:eg</p>
  
  <pre><code>create or replace PACKAGE BODY                                                                                                                                                                                                      fin_statement_spool
  AS
     PROCEDURE fin_main_spool(vacid in VARCHAR2, vfromdate in date, vtodate in date,c1 out  SYS_REFCURSOR,c2 out  SYS_REFCURSOR)
     AS
        cramount            NUMBER;
        dramount            NUMBER;
        countcr             NUMBER;
        countdr             NUMBER;
  BEGIN
      OPEN c1 FOR
          SELECT
              .......;
   OPEN c2  FOR
          SELECT ........;
   BEGIN
        FOR i IN c1--Error is here
        LOOP
          rnum        := 0;
          cramount    := 0;
          dramount    := 0;
          countdr     := 0;
          countcr     := 0;
         ..........
  </code></pre>
  
  <p>Isn't this the right way?</p>