Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.33 DROP PACKAGE

Name

DROP PACKAGE -- remove a package

Synopsis

DROP PACKAGE [ BODY ] name

Description

DROP PACKAGE drops an existing package. To execute this command you must be a superuser or the owner of the package. If BODY is specified, only the package body is removed – the package specification is not dropped. If BODY is omitted, both the package specification and body are removed.

Parameters

name

The name (optionally schema-qualified) of a package to remove.

Examples

This command will remove the emp_admin package:

DROP PACKAGE emp_admin;

See Also

CREATE PACKAGE, CREATE PACKAGE BODY

Previous PageTable Of ContentsNext Page