title: PLS-00103 Oracle stored procedure error
body: <p>I am new to stored procedures.
  I am trying to run stored procedure and getting these errors:
  I am getting PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:     begin function pragma procedure...
  PLS-00103: Encountered the symbol "RETURN" when expecting one of the following:     * &amp; = - + &lt; / > at in is mod remainder not rem then...
  I have tried searching for what causes these errors and for examples similar to this, but results were not sufficient. Any clues as to why these errors are happening?
  here is the code:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE LIST_ACTIONS_CHECK_ADD 
  (
    LISTNAME IN VARCHAR2  
  ) AS 
  BEGIN
   DECLARE CNT NUMBER;
   SELECT COUNT(LIST_NAME) INTO CNT FROM LISTS_MASTER WHERE LIST_NAME = LISTNAME;
  IF (CNT &gt; 0)
   RETURN 1
  ELSE
   RETURN 0
  END IF;
  END LIST_ACTIONS_CHECK_ADD;
  </code></pre>
  
  <p>New Code:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE LIST_ACTIONS_CHECK_ADD 
  (
    P_LISTNAME IN VARCHAR2  
  ) 
  AS 
   L_CNT NUMBER;
  BEGIN
   SELECT COUNT(LIST_NAME) 
     INTO L_CNT 
     FROM LISTS_MASTER 
    WHERE LIST_NAME = P_LISTNAME;
   IF (L_CNT &gt; 0)
     RETURN 1;
   ELSE
     RETURN 0;
    END IF;
  END LIST_ACTIONS_CHECK_ADD;
  </code></pre>