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

From: Praveen <spraveen2001_at_yahoo.com>
Date: 31 Jul 2003 22:51:01 -0700
Message-ID: <98d8ec76.0307312151.60497528_at_posting.google.com>


Hi Matt,

I'm using 8.1.7.0.0 version. In my case, If i use UNION, doesn't fulfill my requirement. I have to go for UNION ALL only.

Thanks,
Praveen

mmiller_at_highpacific.com (M David) wrote in message news:<10c1a5f0.0307311006.10596ee0_at_posting.google.com>...
> 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 Fri Aug 01 2003 - 07:51:01 CEST

Original text of this message