create or replace procedure emp_cur7
IS
v_empno emp.empno%type;
v_ename emp.ename%type;
v_job emp.job%type;
v_sal emp.sal%type;
v_tot number;
cursor emp_cur7 IS
select empno, ename, job, sal
from emp
where job = 'MANAGER';
BEGIN
open emp_cur7;
LOOP
FETCH
emp_cur7
INTO
v_empno, v_ename,v_job,v_sal;
v_tot := v_tot + v_sal;
dbms_output.put_line(v_empno||' :'||v_ename||' :'||v_job||' :'||v_sal);
Exit when
emp_cur7%NOTFOUND;

END LOOP;
dbms_output.Put_line('total salary'||'--'||v_tot);
CLOSE emp_cur7;
end;
/