does the same query fail when run in sqlplus?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Morten" <usenet_at_kikobu.com> wrote in message
news:3CD7DA4D.9050607_at_kikobu.com...
> Morten wrote:
> >
> > I did some more searches on metalink. I found that removing the
> > ORDER BY line "resolves" this issue. Maybe someone remember this
> > behaviour? I'm trying to locate the proper TAR.
> >
> > SELECT id, score(1) "score"
> > FROM ccs_search
> > WHERE contains(content, '((test%)*(1/10))', 1) > 1
>
> That was a bit premature, seems that I just got "lucky". The
> query just broke a bit later than the one with the ORDER BY clause..
>
> Tried sqlplus:
>
> SQL> SELECT id, score(1) "score"
> 2 FROM ccs_search
> 3 WHERE contains(content, '((test%)*(1/10))', 1) > 1
> 4 ORDER BY score(1) DESC;
> SELECT id, score(1) "score"
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
> Mmm...
>
Received on Tue May 07 2002 - 10:41:30 CDT
