Re: end-of-file on communication channel while executing a sql query

Hi Matt,

Thanks for your response.

Regarding this error, i searched the whole site. In SearchDatabase.com site, the experts are saying that, there is some problem with Session and we need to trace out in the log file and send that to Oracle Support. If u get the same error again, send the log to oracle support.

Thanks,
Praveen

mmiller_at_highpacific.com (M David) wrote in message news:<10c1a5f0.0307300924.6d2f3df5_at_posting.google.com>...
> spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0307180436.18b6eab4_at_posting.google.com>...
> > Hi All,
> >
> > I have a query something like this..
> >
> > select col1, col2, col3 from (
> > select col1,col2,col3,col4 from table1
> > union all
> > select col1,col2,col3,col4 from table2
> > )
> >
> > Here col3 is of long raw datatype. If i run this query, after
> > returning some rows, the oracle is saying "end-of-file on
> > communication channel".
> >
> > Can anyone pls help me!!
> > Thanks in Advance,
> > Praveen
>
>
> Hi Praveen,
>
> I have a similar query causing the same error. It is a select from
> a view with a union in it. The database version is 8.1.7.4. The
> query used to work fine on version 8.1.7.2.
> I also found some messages and Oracle Bug notes that seem to indicate
> that this was a bug with version 7.3 as well.
>
> I will let you know if I find something out.
>
> Thanks,
> Matt
Received on Thu Jul 31 2003 - 14:12:36 CEST