Delete the body of a stored package. This command removes the implementation logic while preserving the package specification and interface.
DROP PACKAGE BODY [IF EXISTS] [ db_name . ] package_nameThe 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).
This page is licensed: CC BY-SA / Gnu FDL