title: Procedure created with compilation errors
body: <p>Below is the procedure I have created. When I execute it I'm getting "<em>Procedure created with compilation errors</em>" I don't understand where I did mistake in below procedure code, someone help me by finding error in the code      </p>
  
  <pre><code>create or replace PROCEDURE newprocedur(inMerid IN VARCHAR2,outCount OUT NUMBER) AS  
    CURSOR c1 IS 
      select CLIENT_COUNT 
       from OP_TMER_CONF_PARENT 
      where MER_ID = inMerid 
      FOR UPDATE OF CLIENT_COUNT;
  BEGIN
    Open c1
    loop
      fetch c1 into outCount;
      exit when c1%NOTFOUND;
      outCount:=outCount+1;
      update OP_TMER_CONF_PARENT 
         set CLIENT_COUNT = outCount 
       where current of c1;
    end loop;
    close c1;
  END;
  </code></pre>
  
  <p>Thanks in advance</p>