Re: End of communication Channel

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.
>
>
>
>
Received on Wed Jan 30 2002 - 21:28:37 CST