Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
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:
|
Prerequisites
The object type body must be in your own schema or you must have the DROP
ANY
TYPE
system privilege.
Syntax
drop_type_body::=
Semantics
schema
Specify the schema containing the object type. If you omit schema
, then Oracle Database 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_typ1
, which was created in "Object Type Examples":
DROP TYPE BODY data_typ1;