Delete the body of a stored package. This command removes the implementation logic while preserving the package specification and interface.
Syntax
DROP PACKAGE BODY [IF EXISTS] [ db_name . ] package_name
Description
The DROP PACKAGE BODY statement can be used when is set.
The DROP PACKAGE BODY statement drops the package body (that is, the implementation) which was created using the statement.
Note, DROP PACKAGE BODY drops only the package implementation, but does not drop the package specification. Use to drop the package entirely (i.e. both implementation and specification).