title: Error on creating stored procedure under Oracle - PLS-00103
body: <p>Im trying to create a <strong>stored procedure that calls another a number of times</strong>. This is done so by <strong>using a for each loop</strong>. All the development is under <strong>oracle sql developer Version 3.0.04</strong>.</p>
  
  <pre><code>    CREATE OR REPLACE PROCEDURE Z_INBILLABILITYSERV
      IS BEGIN
        DECLARE
          ano VARCHAR2(4); 
        BEGIN
          select EXTRACT(YEAR FROM sysdate) into ano from dual;
          FOR dat IN (SELECT * FROM Z_FECHOMES WHERE MES &lt;= 
                     (select EXTRACT(MONTH FROM sysdate) from dual )and ANO = ano)
          LOOP
            call z_insertbillability(dat.periodo_inicio,dat.periodo_fim,
                                                                  dat.ano,dat.mes);
          END LOOP;
        END;
      END;
  </code></pre>
  
  <p>Im having the following error:</p>
  
  <p><strong>Error(9,12): PLS-00103: Encountered the symbol "Z_INSERTBILLABILITY" when expecting one of the following:     := . ( @ % ; The symbol ":=" was substituted for "Z_INSERTBILLABILITY" to continue.</strong></p>
  
  <p>If anyone have an idea or a tip i would be glad to now and would appreciate a lot. </p>