1. SQL Language Reference
  2. SQL Statements: DROP LIBRARY to DROP SYNONYM
  3. DROP LIBRARY

DROP LIBRARY

Purpose

Use the DROP LIBRARY statement to remove an external procedure library from the database.

See Also:

CREATE LIBRARY for information on creating a library

Prerequisites

You must have the DROP ANY LIBRARY system privilege.

Syntax

drop_library::=

Description of drop_library.eps follows
Description of the illustration drop_library.eps

Semantics

IF EXISTS

Specify IF EXISTS to drop an existing object.

Specifying IF NOT EXISTS with DROP results in ORA-11544: Incorrect IF EXISTS clause for ALTER/DROP statement.

library_name

Specify the name of the external procedure library being dropped.

Examples

Dropping a Library: Example

The following statement drops the ext_lib library: 

DROP LIBRARY ext_lib;