title: Error is occurring during execution of procedure in oracle
body: <p>I am getting the error during executing the below procedure.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE P_SUMIT (P_FEED IN FEED.FEED_ID%TYPE, P_OPCO_ID IN FEED.OPCO_ID%TYPE)
  AS
  BEGIN
  DECLARE V_PCF_PATTERN FEED.PCF_PATTERN%TYPE;
  DECLARE CURSOR C_FEED FOR SELECT PCF_PATTERN FROM FEED WHERE FEED_ID=P_FEED AND OPCO_ID=P_OPCO_ID;
    OPEN C_FEED;
    LOOP
      FETCH C_FFED INTO V_PCF_PATTERN;   
      EXIT WHEN C_FEED%NOTFOUND;
      DBMS_OUTPUT.PUT_LINE(V_PCF_PATTERN);
     END LOOP;
     CLOSE C_FEED;
   END;
  </code></pre>
  
  <p>Error logs :</p>
  
  <pre><code>3/1            PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:
  
     begin function pragma procedure subtype type &lt;an identifier&gt;
     &lt;a double-quoted delimited-identifier&gt; current cursor delete
     exists prior external language
  The symbol "begin" was substituted for "DECLARE" to continue.
  
  4/1            PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following:
  
     begin function pragma procedure subtype type &lt;an identifier&gt;
     &lt;a double-quoted delimited-identifier&gt; current cursor delete
     exists prior
  </code></pre>
  
  <p>Please assist.</p>