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  8820  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: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
