Re: stored procedure executing for infinite time

[amarendra sahoo]

Hi Peter,

Thanks for your reply.

I put the code like below. But it's showing a syntax error.

Could you please suggest where should I put this code.


IF IMark >= v_CPassmark THEN
SET Result = 'PASS';
SET Remark = 'Grace Applied';
INSERT INTO student_mark(Stu_Name, Course_Name,Mark_Secured,Result,Remarks) VALUES(SName, CName,IMark,Result,Remark);
ELSE
SET Result = 'FAIL';
SET Remark = 'Grace Applied';
INSERT INTO student_mark(Stu_Name, Course_Name,Mark_Secured,Result,Remarks) VALUES(SName, CName,IMark,Result,Remark);

END IF;

if v_finished then LEAVE
END if;

END LOOP ;

CLOSE student_cursor;
END