You can use the DROP PROCEDURE statement to delete a procedure form the database.
DROP PROCEDURE [ IF EXISTS ] name [ (parameters) ] [ CASCADE | RESTRICT ];
name is the name of the procedure to be dropped.
Usage of IF EXISTS, CASCADE, or RESTRICT is not compatible with Oracle databases. For more information about these options, see the DROP PROCEDURE statement in the Database Compatibility for Oracle Developers Reference Guide.
The following example describes how to drop the previously created procedure:
DROP PROCEDURE simple_procedure;