create or replace procedure sumemp(
sdeptno in emp.deptno%type,
ssal out emp.sal%type,
number out emp.empno%type) is
begin
select sum(sal),count(empno) into ssal,number from emp where deptno=sdeptno;
exception
when others then
dbms_output.put_line('errors');
end sumemp;
/