Re: End of communication Channel

Your Oracle shadow process/thread probably crashed (meaning you have hit a bug..). Look for trace files in user_dump_dest or background_dump_dest directories, they may give you a clue or else check metalink or call oracle support and hand them the tracefile.

Regards,
Andre van Winssen

"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 - 10:15:02 CST