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