title: Compile Error for Oracle Procedure
body: <p>I have the following PL/SQL code in a script and am trying to run it in SQL*Plus: </p>
  
  <pre><code>create or replace procedure add_employee 
  (fname IN varchar2(20), lname IN varchar2(25), email IN varchar2(25), job IN varchar2(25))
  AS
  eid INTEGER := 300;
  BEGIN
      insert into Employees (employee_id, first_name, last_name, email, hire_date, job_id) 
      values (eid, fname, lname, email, job);
  END add_employee;
  /
  </code></pre>
  
  <p>I get the following error: </p>
  
  <pre><code>Errors for PROCEDURE ADD_EMPLOYEE:
  
  LINE/COL
  ---------------------------------------------------------------------------
  ERROR
  ---------------------------------------------------------------------------
  
  1/42
  PLS-00103: Encountered the symbol "(" when expecting one of the following:
  
     := . ) , @ % default character
  The symbol ":=" was substituted for "(" to continue.
  </code></pre>
  
  <p>I don't understand what the issue is. I have written other procedures where the opening parenthesis follows the procedure name without any problem. </p>