Drops an existing package or package body from the database.
Prerequisites
Before you begin, ensure that you have:
Superuser privileges, or ownership of the package to drop
Syntax
DROP PACKAGE [ BODY ] nameParameters
| Parameter | Description |
|---|---|
BODY | Drops only the package body. The package specification remains intact. If omitted, both the package specification and body are dropped. |
name | The name of the package to drop. Can be schema-qualified. |
Example
Drop the emp_admin package (specification and body):
DROP PACKAGE emp_admin;