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 8855 sp**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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*****@highpac ific.com (M David) wrote in message news:<10******* *************** ****@posting.go ogle.com>... sp**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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*****@highpac ific.com (M David) wrote in message news:<10******* *************** ****@posting.go ogle.com>... sp**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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*****@highpac ific.com (M David) wrote in message news:<10******* *************** ****@posting.go ogle.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**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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*****@highpac ific.com (M David) wrote in message news:<10******* *************** ****@posting.go ogle.com>... sp**********@ya hoo.com (Praveen) wrote in message news:<98******* *************** ****@posting.go ogle.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 executed in the server, which is
back end? I think I am confused with the term front end and back end here.
Please advise. Thanks!!
|
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 issue to the
end of an issue and I'd like to determine how many business hours these
issues were open.
Issue BeginDt Enddt Total hours
1 3/29/05 5:00 PM 4/1/05 2:00 PM 69
...
|
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 linking the SQL tables to an Access back-end and then linking the
linked tables in the Access back-end to the Access front-end. Doesn't work
at all.
Obviously, this can't be done. What is the best way to replace an Access
back-end with SQL tables?
|
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 have done the following:
.. Copied the table in the back end and given the copy a new name
.. Created a table with the identical name to the back end copy in the front end
.. Used the linkage process to link the table reference in the front end...
|
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 System.Windows.Forms.Form
Dim points() As Point = {}
Dim pen As New Pen(Color.FromArgb(255, 0, 0, 255))
Protected Overrides Sub OnPaint(ByVal e As
System.Windows.Forms.PaintEventArgs)
|
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 I change the End
statement to Application.Exit(), the
codes after the statement still been executed. So,
|
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 question is, is it OK to
use End or it is there a cleaner way to close the app? Keep in mind that I
want everything taken down, including any warning dialogue box shown from
the timer, and any others that happen to be still open in the MDI parent...
|
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 table in back-end database (it give me all records). All is OK - back end database is not locked, but when I click in this combo, back end databse is locking by Me???. My question is there way to select data from this combo without to lock back-end...
|
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>
#include <vector>
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |