Syntax

DROP PACKAGE BODY [IF EXISTS]  [ db_name . ] package_name

Description

The DROP PACKAGE BODY statement can be used when Oracle SQL_MODE is set.

The DROP PACKAGE BODY statement drops the package body (i.e the implementation), previously created using the CREATE PACKAGE BODY statement.

Note, 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).

See also

• CREATE PACKAGE
• SHOW CREATE PACKAGE
• DROP PACKAGE
• CREATE PACKAGE BODY
• SHOW CREATE PACKAGE BODY
• Oracle SQL_MODE