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

Praveen,

   it is good to know I am not alone. Would you mind relaying your Oracle version number? '

Another Clue.

   I was able to get my query to run by changing UNION ALL to UNION. In my case it gives the same result. It may not work for you. But at least it is something to tell Oracle.   

Matt

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0307310412.1e191d54_at_posting.google.com>...
> 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 - 20:06:11 CEST