title: Create package with procedure Oracle
body: <p>I have created a package with one procedure to delete any countries from a table where <code>country_ID</code> does not exist. I wrote this code:</p>
  <pre><code>CREATE PACKAGE cust_sa AS
    PROCEDURE del_cn3(c_cntry_id COUNTRIES.COUNTRY_ID%TYPE)
    IS
        v_error_code NUMBER;
    BEGIN
       DELETE from countries WHERE country_id =c_cntry_id;
          
      IF SQL%NOTFOUND THEN
        DBMS_OUTPUT.PUT_LINE('No such record');
      END IF;
    EXCEPTION WHEN OTHERS THEN
      v_error_code :=SQLCODE;
      IF v_error_code =-2292 THEN
        RAISE_APPLICATION_ERROR(-20004,'Organization ' ||
                                       TO_CHAR(c_cntry_id) ||
                                       ' site details defined for it.');
      END IF;
    END del_cn3;
  END cust_sa;
  /
  </code></pre>
  <p>However, I get the following two errors upon creating this package:</p>
  <blockquote>
  <p>(Line 4) Encountered the symbol V_ERROR_CODE when expecting one of
  the following: language</p>
  <p>(Last line) Encountered the symbol CUST_SA
  when expecting one of the following: ;</p>
  </blockquote>
  <p>Why the errors appear and how to fix them?</p>