Oracle Cursor/Procedure

setserveroutput on

declare
cursor c1 is select empno,ename,sal from emp;
emp_rec c1%rowtype;
begin
if not c1%isopen then
open c1;
end if;
loop
fetch c1 into emp_rec;
exit when c1%notfound;
dbms_output.put_line(emp_rec.ename||' '||emp_rec.sal);
end loop;
close c1;
end;