Re: Getting missing primary invocation for ancillary operator help!

In article <uv8mitg89kmkbq4bt01h54g3ne6dqanoot_at_4ax.com>, Kev says...
>
>Hello All,
>
>When ever I try to do this:
>
>for c in (select score(0),
> id,subjectline
> FROM usenetarticles
> WHERE contains(article, p_Text ,1) > 0 )
>
>blah blah blah
>
>I get this error:
>ORA-29908: missing primary invocation for ancillary operator
>
>I can find nothing about this error except this:
> ORA-29908 missing primary invocation for ancillary operator
>
>Cause: The primary invocation corresponding to an ancillary operator
>is missing.
>
>Action: Add the primary invocation with the same label as the
>ancillary operator.
>
>What do I need to do so the above will work??? I am stuck and
>clueless to say the least on this error.
>

one of the more obscure error messages to be sure ;)

it is saying "hey, there is no ZERO in the contains, hence score(0) isn't valid"

consider:

ask_tom_at_OSI816> select score(0), displayid   2 from WWC_ASK_INDEXED_QUESTIONS$
  3 where contains( text, 'oracle', 1 ) > 0   4 and rownum = 1;
select score(0), displayid

       *
ERROR at line 1:
ORA-29908: missing primary invocation for ancillary operator

ask_tom_at_OSI816> l
  1 select score(1), displayid
  2 from WWC_ASK_INDEXED_QUESTIONS$
  3 where contains( text, 'oracle', 1 ) > 0   4* and rownum = 1
ask_tom_at_OSI816> /

  SCORE(1) DISPLAYID
---------- ----------

        17 1.5662E+12

ask_tom_at_OSI816>

>
>Thanks,
>
>Kev

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp