Deleting a Procedure v13
A procedure can be deleted from the database using the DROP PROCEDURE
command.
Where name
is the name of the procedure to be dropped.
Note
The specification of the parameter list is required in Advanced Server under certain circumstances such as if this is an overloaded procedure. Oracle requires that the parameter list always be omitted.
Usage of
IF EXISTS, CASCADE
, orRESTRICT
is not compatible with Oracle databases. See theDROP PROCEDURE
command in the Database Compatibility for Oracle Developers SQL Guide for information on these options.
The previously created procedure is dropped in this example: