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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Praveen
    #1

    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
    Tags: None
    • M David
      #2
      Re: end-of-file on communication channel while executing a sql query

      spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307180436.18b6 eab4@posting.go ogle.com>...[color=blue]
      > 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[/color]


      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

        Comment

        • Praveen
          #3
          Re: end-of-file on communication channel while executing a sql query

          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

          mmiller@highpac ific.com (M David) wrote in message news:<10c1a5f0. 0307300924.6d2f 3df5@posting.go ogle.com>...[color=blue]
          > spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307180436.18b6 eab4@posting.go ogle.com>...[color=green]
          > > 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[/color]
          >
          >
          > 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[/color]

            Comment

            • M David
              #4
              Re: end-of-file on communication channel while executing a sql query

              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


              spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307310412.1e19 1d54@posting.go ogle.com>...[color=blue]
              > 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
              >
              > mmiller@highpac ific.com (M David) wrote in message news:<10c1a5f0. 0307300924.6d2f 3df5@posting.go ogle.com>...[color=green]
              > > spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307180436.18b6 eab4@posting.go ogle.com>...[color=darkred]
              > > > 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[/color]
              > >
              > >
              > > 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[/color][/color]

                Comment

                • Praveen
                  #5
                  Re: end-of-file on communication channel while executing a sql query

                  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

                  mmiller@highpac ific.com (M David) wrote in message news:<10c1a5f0. 0307311006.1059 6ee0@posting.go ogle.com>...[color=blue]
                  > 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
                  >
                  >
                  > spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307310412.1e19 1d54@posting.go ogle.com>...[color=green]
                  > > 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
                  > >
                  > > mmiller@highpac ific.com (M David) wrote in message news:<10c1a5f0. 0307300924.6d2f 3df5@posting.go ogle.com>...[color=darkred]
                  > > > spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0307180436.18b6 eab4@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[/color][/color][/color]

                    Comment

                    Previous template Next
                    Working...