DROP PROCEDURE

DropProcedure ::= DROP PROCEDURE [ IF EXISTS  ] procedure_name;

create procedure test_pro(
section     number(6),
salary_sum out number(8,2),
staffs_count out integer)
is
begin
   select sum(salary), count(*) into salary_sum, staffs_count from staffs where section_id = section;
end;
/

drop procedure if exists test_pro (section numeric,out salary_sum numeric,OUT staffs_count integer);