Re: stored procedure executing for infinite time

[amarendra sahoo]

Basically it's calculating correctly for all the records. But loop is not terminating for the last record and running infinite times.

select * from student_mark

Records in student_mark table:

# Stu_Name, Course_Name, Mark_Secured, Result, Remarks
'Bhabesh Sahoo', 'Mathematics', '101', 'PASS', 'Grace Applied'
'Jitendra Sahoo', 'Physics', '72', 'PASS', 'Grace Applied'
'Romakanta Patro', 'Chemistry', '66', 'PASS', 'Grace Applied'
'Tarakanath Shimadri', 'Botany', '30', 'PASS', 'Grace Applied'
'Sudhansu Parida', 'Zoology', '97.5', 'PASS', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'
'Amit Agarawal', 'Zoology', '12.5', 'FAIL', 'Grace Applied'