Use a drop procedure statement to drop a standalone procedure.
Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package specification.
Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body.
For faster removal and re-creation, do not use a drop procedure statement. Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS clause.