|Oracle® Database SQL Language Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
Object types are defined using PL/SQL. Please refer to Oracle Database PL/SQL Language Reference for complete information on creating, altering, and dropping object types.
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.
The object type body must be in your own schema or you must have the
TYPE system privilege.
Specify the schema containing the object type. If you omit
schema, then Oracle Database assumes the object type is in your own schema.
Specify the name of the object type body to be dropped.
The following statement removes object type body
data_typ1. See Oracle Database PL/SQL Language Reference for the example that creates this object type.
DROP TYPE BODY data_typ1;