oracle8.1.6 BEGIN :1 := rel_constraint.new( constraint_name => :constraint_name, rel_segment => :segment_id, rel_side => 'two', required_rel_segment => rel_segment.get(:supersite_group_id, 'membership_rel'), creation_user => :user_id, creation_ip => :creation_ip ); END; select object_type from acs_object_types start with object_type = :object_type connect by object_type = prior supertype and rownum < 2 order by decode(host, :search_vhost, 1, 0) desc and rownum < 2