title: Error(1,30): PLS-00103: Encountered the symbol ")"
body: <p>I'm trying to create a procedure using oracle, it should be working fine but i keep getting the following error: </p>
  
  <blockquote>
    <p>Error(1,30): PLS-00103: Encountered the symbol ")" when expecting one of the following:          current delete exists prior </p>
  </blockquote>
  
  <p>here is my procedure: </p>
  
  <pre><code>CREATE PROCEDURE ProductLineSale () 
  BEGIN  
  ALTER TABLE Product_T ADD COLUMN SalePrice decimal(6,2);
  
  UPDATE Product 
  SET SalePrice = .90 * ProductStandardPrice 
  WHERE ProductStandardPrice &gt;= 400; 
  
  UPDATE Product 
  SET SalePrice = .85 * ProductStandardPrice 
  WHERE ProductStandardPrice &lt; 400; 
  
  END
  </code></pre>