Skip Headers

Oracle9i SQL Reference
Release 2 (9.2)

Part Number A96540-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DROP TYPE BODY

Purpose

Use the DROP TYPE BODY statement to drop the body of an object type, 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 along with the body
  • CREATE TYPE BODY for more information on type bodies

Prerequisites

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

Syntax

drop_type_body::=

Text description of statements_910.gif follows
Text description of drop_type_body


Semantics

schema

Specify the schema containing the object type. If you omit schema, then Oracle assumes the object type is in your own schema.

type_name

Specify the name of the object type body to be dropped.

Restriction on Dropping Type Bodies

You can drop a type body only if it has no type or table dependencies.

Example

Dropping an Object Type Body: Example

The following statement removes object type body data_typ (created in "Updating a Type Body: Example"):

DROP TYPE BODY data_typ;