SQL & PL/SQL

Hi All,

When I am executing a query in Oracle Database version 11.2.0.1,I get an error as No more data to read from socket.In my sql query I had given all the joins as left outer join ,but when I comment two outer joins the result will be showing.

My SQL is :


select o.GENERAL_LEDGER as GROUP_NAME,
o.ACCNT_TYPE_CD AS GROUP_TYPE,
o.CUST_STAT_CD AS GROUP_STATUS,
pr1.START_DT AS EFFECTIVE_DATE,
pr1.EMP_STATUS_CD AS ACCOUNT_CONS_STATUS,
con1.OU_MAIL_STOP AS ACCOUNT_CONS_REGION,
con1.PRESENCE_URI AS ACCOUNT_CONS_LOCATION,
con1.FST_NAME||''||con1.LAST_NAME as PRIMARY_CONTACT,
con.FST_NAME||''||con.LAST_NAME as ACCOUNT_CONS_NAME,
org.ALIAS_NAME AS BROKER_AGENCY_NAME,
PR2.START_DT AS BROKER_EFFECTIVE_DATE,
PR2.REL_TYPE_CD AS BROKER_RELATIONSHIP_TYPE,
PR2.EMP_STATUS_CD AS BROKER_RELATIONSHIP_STATUS
from siebel.s_org_ext O
left outer join siebel.s_party_per pr on o.row_id=pr.party_id
left outer join siebel.s_contact con on pr.person_id=con.row_id
left outer join siebel.s_party_rel pr1 on o.row_id=pr1.party_id
left outer join siebel.s_contact con1 on pr1.REL_PARTY_ID = con1.PAR_ROW_ID
left outer join siebel.s_party_rel pr2 on o.row_id=pr2.party_id
left outer join siebel.s_org_ext org on PR2.REL_PARTY_ID=org.ROW_ID
left outer join siebel.s_contact con2 on o.pr_con_id=con2.row_id
left outer join siebel.s_party_rel pr2 on o.PR_PRTNR_OU_ID= pr2.row_id
where o.row_id='1-3A2U'

when I comment last 2 outer join lines then the result will shows.

how can we resolve this error?

Thanks
chitra