DROP PACKAGE

Remove a stored package completely. This command deletes both the package specification (interface) and its body (implementation) from the database.

Syntax

DROP PACKAGE [IF EXISTS]  [ db_name . ] package_name

Description

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

The DROP PACKAGE statement drops a stored package entirely:

• Drops the package specification (earlier created using the CREATE PACKAGE statement).

• Drops the package implementation, if the implementation was already created using the CREATE PACKAGE BODY statement.

See Also

• SHOW CREATE PACKAGE

• CREATE PACKAGE

• CREATE PACKAGE BODY

• DROP PACKAGE BODY

• Oracle SQL_MODE

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