PL/SQL Drop Procedure

In PL/SQL a standalone procedure can be deleted with the DROP PROCEDURE statement.

PL/SQL Drop Procedure Syntax

To delete an existing procedure, use the following syntax:

DROP PROCEDURE procedure_name;

Where:

procedure_name: The name of the procedure.

The following PL/SQL show how to delete existing procedure:

DROP PROCEDURE CreateUser;