Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
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:
|
The object type body must be in your own schema, and you must have
drop_type_body::=
Specify the schema containing the object type. If you omit schema
, then Oracle assumes the object type is in your own schema.
Specify the name of the object type body to be dropped.
You can drop a type body only if it has no type or table dependencies.
The following statement removes object type body data_typ
(created in "Updating a Type Body: Example"):
DROP TYPE BODY data_typ;