Re: End of communication Channel

This definitely sounds like a bug. Contact Oracle support. A fix may already be out for it.

                           Rick

"Tom Dyess" <tdyess_at_dyessindustries.com> writes:

> Yes, Its probably a bug - I had the same problem when excuting a nested sql
> statement in a proc but it worked fine as a single line query - go figure.
> Try running it a different way if you want a quick fix.
>
> Tom
> www.oraclepower.com
>
> "Steven Pannell" <steven.pannell_at_gmx.net> wrote in message
> news:a392nj$169apf$1_at_ID-82797.news.dfncis.de...
> > Hi,
> >
> > If I run the following statement I get an end of communcation channel
> error
> > from Oracle and I am disconnected from the database:
> >
> >
> > SELECT * FROM FORUM WHERE F_ID = F_ID AND F_STATUS = 'P'
> > AND ((CONTAINS(F_TEXT,'hallo') > 0) OR upper(F_TITEL) LIKE '%HALLO%')
> > ORDER BY F_ID DESC
> >
> > However when I remove the F_ID = F_ID from the statement it works fine.
> as
> > follows:
> >
> >
> > SELECT * FROM FORUM WHERE F_STATUS = 'P'
> > AND ((CONTAINS(F_TEXT,'hallo') > 0) OR upper(F_TITEL) LIKE '%HALLO%')
> > ORDER BY F_ID DESC
> >
> > OK, it was a mistake that this was in the statment but I am wondering why
> > Oracle would disconnect me when running the statement! An Ideas?
> >
> > Thanks,
> > Steve.
> >
> >
> >
> >
>
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.