DROP PACKAGE BODY [IF EXISTS] [ db_name . ] package_name
DROP PACKAGE BODY statement can be used when Oracle SQL_MODE is set.
DROP PACKAGE BODY statement drops the package body (i.e the implementation), previously created using the CREATE PACKAGE BODY statement.
DROP PACKAGE BODY drops only the package implementation, but does not drop the package specification. Use DROP PACKAGE to drop the package entirely (i.e. both implementation and specification).