DROP PACKAGE BODY

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 Oracle SQL_MODE is set.

The DROP PACKAGE BODY statement drops the package body (that is, the implementation) which was 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

_{This page is licensed: CC BY-SA / Gnu FDL}