3 Replies Latest reply: Oct 30, 2012 11:56 PM by 970843 RSS

    Procedure created with compilation errors

    970843
      Below is the procedure i have created when i execute im getting "Procedure created with compilation errors" i dont understand where i did mistake in below procedure code, someone help me by finding error in the 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;