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;
fetch c1 into outCount;
exit when c1%NOTFOUND;
update OP_TMER_CONF_PARENT set CLIENT_COUNT = outCount where current of c1;