oracle8.1.6 begin acs.remove_user( user_id => :user_id ); end; begin person.del( person_id => :person_id ); end; begin :1 := acs_rel.new ( rel_type => 'user_portrait_rel', object_id_one => :user_id, object_id_two => :item_id); end; (object_type = 'group' or object_type = 'person') object_type = :start_with select types.pretty_name, types.object_type, types.tree_level, types.indent, case when valid_types.object_type = null then 0 else 1 end as valid_p from (select t.pretty_name, t.object_type, level as tree_level, replace(lpad(' ', (level - 1) * 4), ' ', ' ') as indent, rownum as tree_rownum from acs_object_types t connect by prior t.object_type = t.supertype start with $start_with_clause ) types, (select object_type from rel_types_valid_obj_two_types where rel_type = :rel_type ) valid_types where types.object_type = valid_types.object_type(+) order by tree_rownum