In Oracle 9i object type inheritance is possible. Using this feature quickly leads to having many types with many dependencies. Changing one of the base types can, as far as i know, only be done by either using drop type force and then recreating the type, or by using type evolution.
Currently we have created a plugin that drops the type and then recompiles it when pressing F7 as this gives a behaviour very similar to recompiling packages and procedures (dependencies are invalidated). This however is a problem when the object type is part of a table (there are defined columns of the type). If the table data is to be preserved only type evolution is possible. However after a type has been evoluted its specification no longer looks very pretty in the editor.
Are there any plans for an interface similar to the one for editing tables ? (as type specifications are handled similar to tables, and it seems that the information for such an interface is available in the all_type views) or perhaps another more convenient way of developing object types ?
Currently we have created a plugin that drops the type and then recompiles it when pressing F7 as this gives a behaviour very similar to recompiling packages and procedures (dependencies are invalidated). This however is a problem when the object type is part of a table (there are defined columns of the type). If the table data is to be preserved only type evolution is possible. However after a type has been evoluted its specification no longer looks very pretty in the editor.
Are there any plans for an interface similar to the one for editing tables ? (as type specifications are handled similar to tables, and it seems that the information for such an interface is available in the all_type views) or perhaps another more convenient way of developing object types ?
