Executing the following view drops the Oracle connection (end of communciation).
I followed up all the views and they all seem to work indvidually. Then I tried to play around with the outer joins and the view works if I take out the second outer join(party_id). Is there something that I missiing in Oracle 9i (ver 9.2)? May be sombody would point me in the right direction?
CREATE OR REPLACE VIEW REL_CONSTRAINTS_VIOLATED_ONE ( CONSTRAINT_ID,
CONSTRAINT_NAME, REL_ID, CONTAINER_ID, PARTY_ID,
REL_TYPE, REL_SEGMENT, REL_SIDE, REQUIRED_REL_SEGMENT
) AS select constrained_rels.constraint_id, constrained_rels.constraint_name,
constrained_rels.rel_id, constrained_rels.container_id,
constrained_rels.party_id, constrained_rels.rel_type,
constrained_rels.rel_segment,constrained_rels.rel_side,
constrained_rels.required_rel_segment
from (select rel_constraints.constraint_id, rel_constraints.constraint_name,
r.rel_id, r.container_id, r.party_id, r.rel_type,
rel_constraints.rel_segment,
rel_constraints.rel_side,
rel_constraints.required_rel_segment
from rel_constraints, rel_segment_party_map r
where rel_constraints.rel_side = 'one'
and rel_constraints.rel_segment = r.segment_id
) constrained_rels,
rel_segment_party_map rspm
where rspm.segment_id(+) = constrained_rels.required_rel_segment
and rspm.party_id(+) = constrained_rels.container_id