procedure emp_count
create or replace procedure emp_count(p_total out number)
as
begin
select count(*) into p_total from users ;
end;
----------
declare
v_total number;
begin
emp_count(v_total);
dbms_output.put_line('users is:'||v_total);
end;
www.2cto.com