By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,323 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,323 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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
Jul 19 '05 #2

P: n/a
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

mm*****@highpacific.com (M David) wrote in message news:<10**************************@posting.google. com>...
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #3

P: n/a
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
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

mm*****@highpacific.com (M David) wrote in message news:<10**************************@posting.google. com>...
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #4

P: n/a
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

mm*****@highpacific.com (M David) wrote in message news:<10**************************@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
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

mm*****@highpacific.com (M David) wrote in message news:<10**************************@posting.google. com>...
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.