469,958 Members | 1,947 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,958 developers. It's quick & easy.

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

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
4 8659
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
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
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
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.

Similar topics

2 posts views Thread by Jeff Pritchard | last post: by
4 posts views Thread by John Baker | last post: by
8 posts views Thread by Murt | last post: by
5 posts views Thread by Bob | last post: by
4 posts views Thread by Michael | last post: by
reply views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.