Dropping packages (PL/SQL)

You can drop a package if it is no longer needed. Alternatively, if you want to reuse the package, you have the option to drop only the package body.

Syntax

Read syntax diagramSkip visual syntax diagramDROPPACKAGEBODY package-name

Description

BODY
Specifies that only the package body is to be dropped. If this keyword is omitted, both the package specification and the package body are dropped.
package-name
Specifies the name of a package.

Examples

The following example shows how to drop only the body of a package named EMP_ADMIN:
DROP PACKAGE BODY emp_admin
The following example shows how to drop both the specification and the body of the package:
DROP PACKAGE emp_admin