title: Creating stored procedure in Oracle -17110 - Warning: execution completed with warning
body: <p>I tried creating following stored procedure found <a href="http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/create_procedure.htm#LNPLS01373" rel="nofollow">here</a> using Execute Query client connected to my Oracle server (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0)</p>
  
  <pre><code>CREATE PROCEDURE remove_emp (employee_id NUMBER) AS
     tot_emps NUMBER;
     BEGIN
        DELETE FROM employees
        WHERE employees.employee_id = remove_emp.employee_id;
     tot_emps := tot_emps - 1;
     END;
  /
  </code></pre>
  
  <p>I'm getting following,</p>
  
  <blockquote>
    <p>Procedure created.</p>
    
    <p>17110 - Warning: execution completed with warning</p>
  </blockquote>
  
  <p>Appreciate any help on this.</p>