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
4  8822  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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Matt |
last post by:
I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is
for server side programming and dynamic content generation, how could it is
called front end? Because I thought it is...
|
by: mitchchristensen |
last post by:
I have a transaction log that tracks issues from a call center. Each
time an issue is assigned to someone else, closed, etc. I get a time
stamp. I have these time stamps for the beginning of an...
|
by: Jeff Pritchard |
last post by:
Some time ago I am sure I came across something that said this was possible,
though it doesn't seem to work.
A client wants to replace an Access back-end with SQL Server tables. We have
tried...
|
by: John Baker |
last post by:
Hi:
I have an application that has a back end and a front end. I need to add a table which is
identical to one in the back end, and then use it for a temporary holing place form some
records. I...
|
by: Murt |
last post by:
on my inbox below i want the loop to quit if the user enters End,
It does not function as written,
any ideas?
thanks
----------------------
Dim inputString As String
|
by: Ashish |
last post by:
Hi, please take a look at the following code. (I've ommitted the Windows
generated code)
--------------------------------
Imports System.Drawing.Drawing2D
Public Class Form1
Inherits...
|
by: oktave |
last post by:
Hi,
Anybody would like to tell me ther defference between
Application.Exit() and
End? I can use
End to end my application no matter how
many forms and codes after the End
statement. But since...
|
by: Bob |
last post by:
My app shows a modal MDI parent form, and creates a timer that ticks every
ten minutes to boot unresposive users at 3 in the morning. Below is a
simplified working example with no time check. My...
|
by: shapala |
last post by:
Hi all!
Can anybody help me with this problem:
I have a database splited with to front-end back end application. At front end I have a form who contains combo box. This combo has row source to a...
|
by: Michael |
last post by:
Hi,
I am confused about end() in the following code. end() does not point
to the 10th element? Why? Does end() means like '\0' in a char x ?
Thanks in advance,
Michael
#include <iostream>...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
