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

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 Wed Jul 30 2003 - 19:24:47 CEST