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::=
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;