v1.1

DROP PROCEDURE

Function

DROP PROCEDURE deletes a stored procedure.

Precautions

None

Syntax

DROP PROCEDURE [ IF EXISTS  ] procedure_name ;

Parameter Description

IF EXISTS

Reports a notice instead of an error if the specified stored procedure does not exist.
procedure_name

Specifies the name of the stored procedure to be deleted.

Value range: an existing stored procedure name

Examples

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);