title: PL/SQL: statement ignored when inserting
body: <p>I'm trying to create a stored procedure that can only be executed in the month of march based on system date. Here is a snippot of such code:</p>
  
  <pre><code>CREATE PROCEDURE sp_time_window (
      p_sales_ID    in sales.sales_ID%TYPE,
      p_product     in sales.product%TYPE,
      p_unitCost    in sales.unitcost%TYPE,
      p_quantity    in sales.quantity%TYPE)
  
      IS BEGIN
      DECLAR v_date varchar(3)
  
      BEGIN 
  
      SELECT TO_CHAR(sysdate,'MM') into v_date from duaL
  
      IF (v_date in ('MAR')) THEN
         INSERT INTO sales (sales_ID, product, unitcost, quantity) values
         (p_sales_ID, p_  product, p_unitCost, p_quantity);
     ENDIF;
     END;
     END;
      /
  </code></pre>
  
  <p>ORACLE gives me this error:</p>
  
  <pre><code>LINE/COL      ERROR
  --------     ---------------------------------------------------
  14/2          PL/SQL: SQL Statement ignored
  16/5          PL/SQL: ORA-00933: SQL command not properly ended
  </code></pre>
  
  <p>please help </p>