oracle8.1.6
BEGIN
:1 := rel_constraint.new(constraint_name => :constraint_name,
rel_segment => :rel_segment,
rel_side => :rel_side,
required_rel_segment => :required_rel_segment,
creation_user => :creation_user,
creation_ip => :creation_ip
);
END;
select viol.rel_id, acs_object.name(viol.party_id) as name
from rel_constraints_violated_one viol
where viol.constraint_id = :constraint_id
UNION ALL
select viol.rel_id, acs_object.name(viol.party_id) as name
from rel_constraints_violated_two viol
where viol.constraint_id = :constraint_id