Re: Getting missing primary invocation for ancillary operator help!

Oh I forgot that I do have the score(0) as revl in the query so it reads as:

for c in (select score(0) as revl,

               id,subjectline
                 FROM usenetarticles 
                   WHERE contains(article, p_Text ,1) > 0 )

On Sat, 16 Jun 2001 02:20:03 -0700, Kev <java2e_at_yahoo.com> wrote:

>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.
>
>
>Thanks,
>
>Kev
Received on Sat Jul 21 2001 - 16:22:19 CDT