The problem to your specific problem is at the end of the lines 12,13, and 14. You do not need the .EName after the call to the cursor record. Then you have the problem of a never ending loop.
Try the following implicit cursor:
begin
for rec in (select EName from EMP)
loop...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.