Oracle® Database PL/SQL Language Reference 11g Release 2 (11.2) Part Number E10472-02 |
|
|
View PDF |
The DROP
PACKAGE
statement drops a stored package from the database. This statement drops the body and specification of a package.
Note:
Do not use this statement to drop a single object from a package. Instead, re-create the package without the object using the "CREATE PACKAGE Statement" and "CREATE PACKAGE BODY Statement" with theOR
REPLACE
clause.Topics:
Prerequisites
The package must be in your own schema or you must have the DROP
ANY
PROCEDURE
system privilege.
Syntax
drop_package::=
Semantics
BODY
Drops only the body of the package. If you omit this clause, then the database drops both the body and specification of the package.
When you drop only the body of a package but not its specification, the database does not invalidate dependent objects. However, you cannot call a procedure or stored function declared in the package specification until you re-create the package body.
schema
The name of the schema containing the package. The default is your own schema.
package
The name of the package to be dropped.
The database invalidates any local objects that depend on the package specification. If you subsequently reference one of these objects, then the database tries to recompile the object and returns an error if you have not re-created the dropped package.
If any statistics types are associated with the package, then the database disassociates the statistics types with the FORCE
clause and drops any user-defined statistics collected with the statistics types.
See Also:
Oracle Database SQL Language Reference for information about the ASSOCIATE
STATISTICS
statement
Oracle Database SQL Language Reference for information about the DISASSOCIATE
STATISTICS
statement
Example
Dropping a Package: Example This statement drops the specification and body of the emp_mgmt
package, which was created in "Creating a Package Body: Example", invalidating all objects that depend on the specification:
DROP PACKAGE emp_mgmt;
Related Topics