存储过程-声明参数并输出查询结果

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;
*/