create or replace procedure p1(p_deptno number,p_con out number)
is
begin
select count(*) into p_con
from emp
where sal > (select avg(sal) from emp where deptno = p_deptno);
end;

/

declare
v_count number(2);
begin
p1(20,v_count);
dbms_output.put_line(v_count);
end;