Had to remove the cascade_p feature of the new drop_type procedure, because implementing it in Oracle would require a huge reorganization of the order of definition of object and metadata tables and their associated tables, which just is not going to happen.