title: Error(14,5): PL/SQL: ORA-00933: SQL command not properly ended when creating stored procedure
body: <p>I am trying to create a stored procedure in Oracle 18c express edition below</p>
  <pre><code>CREATE OR REPLACE PROCEDURE GETTOP15CLIENTS
  AS
  BEGIN
      DECLARE  
          customerId NUMBER;
          totalOrders NUMBER;
      BEGIN
  
      SELECT C.customer_id, COUNT(O.order_id) INTO customerId, totalOrders 
      FROM CUSTOMERS C
      JOIN ORDERS O ON O.customer_id = C.customer_id
      GROUP BY C.customer_id
      HAVING COUNT(O.order_id) &gt; 15
      ORDER BY COUNT(O.order_id) DESC
  
      END;
  END;
  </code></pre>
  <p>but I am getting the following errors</p>
  <blockquote>
  <p>Error(8,5): PL/SQL: SQL Statement ignored<br />
  Error(14,5): PL/SQL: ORA-00933: SQL command not properly ended<br />
  Error(15,4): PLS-00103: Encountered the symbol &quot;end-of-file&quot;</p>
  </blockquote>
  <p>This is my very first time in Oracle.Any help would be appreciated!</p>
  <p>Thank you.</p>