Synopsis
DROP PACKAGE
[BODY][schema
.]package_name
Removes a package ( package_name) from the
database.
Keyword
- BODY
Specifies that only the package body is to be dropped. If this
keyword is omitted, both the package body and specification will be
removed.
Note
The package to be dropped must be in your schema, or you must have
the DROP ANY PROCEDURE privilege to remove a package from another
schema.
Example
The following example removes the package salcalc from the database:
DROP PACKAGE salcalc