create or replace procedure p1(p_sal1 number,p_sal2 number,p_con out number)
is
begin
select count(*) into p_con from emp
where sal between p_sal1 and p_sal2;
end;
/
declare
v_count number(2);
begin
p1(1000,3000,v_count);
dbms_output.put_line(v_count);
end;
