DROP TYPE BODY

Syntax

Purpose

To drop the body of an object, varray, or nested table type. When you drop a type body, the object type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the object type, although you cannot call the member functions.

See Also: "DROP TYPE" for information on dropping the specification of an object. "CREATE TYPE BODY" for more information on type bodies.

Prerequisites

The object type body must be in your own schema, and you must have

• the CREATE TYPE or CREATE ANY TYPE system privilege, or

• the DROP ANY TYPE system privilege

Keywords and Parameters

schema	is the schema containing the object type. If you omit schema, Oracle assumes the object type is in your own schema.
type_name	is the name of the object type body to be dropped. Restriction: You can drop a type body only if it has no type or table dependencies.

Example

The following statement removes object type body RATIONAL:

DROP TYPE BODY rational;