Name

DROP PACKAGE

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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset