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

From: Praveen <spraveen2001_at_yahoo.com>
Date: 18 Jul 2003 05:36:22 -0700
Message-ID: <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 Received on Fri Jul 18 2003 - 14:36:22 CEST

Original text of this message