40867

ORA-29908: missing primary invocation for ancillary operator

I have an error that I can't seem to figure out. Anyone has an idea what I'm doing wrong here? Please assume that images has place, subject, description, and testing appears several times in subject or place or description. Also, I did set the ConText initialization parameter TEXT_ENABLE to be true.

SELECT 4*SCORE(1) + 2*SCORE(2) + SCORE(3) AS RANK FROM images i WHERE CONTAINS(i.subject, 'testing', 1)>0 OR CONTAINS(i.place, 'testing', 2)>0 OR CONTAINS(i.description, 'testing', 3)>0 ORDER BY RANK;

Answer1:

I manged to solve the problem by surrounding the current query with another query and pulling the ORDER BY RANK to the outside query. Like so:

SELECT * FROM (SELECT 4*SCORE(1) + 2*SCORE(2) + SCORE(3) AS RANK FROM images i WHERE CONTAINS(i.subject, 'testing', 1)>0 OR CONTAINS(i.place, 'testing', 2)>0 OR CONTAINS(i.description, 'testing', 3)>0) ORDER BY RANK;

Answer2:

I can't reproduce on 10.2.0.4. What is your DB version?

test script:

CREATE TABLE text_data ( txt1 VARCHAR2(4000), txt2 VARCHAR2(4000), txt3 VARCHAR2(4000) ); INSERT INTO text_data (SELECT text, text, text FROM all_source WHERE ROWNUM <= 1e4); CREATE INDEX txt1 ON text_data (txt1) INDEXTYPE IS ctxsys.context; CREATE INDEX txt2 ON text_data (txt2) INDEXTYPE IS ctxsys.context; CREATE INDEX txt3 ON text_data (txt3) INDEXTYPE IS ctxsys.context; SELECT 4 * SCORE(1) + 2 * SCORE(2) + SCORE(3) AS RANK FROM text_data i WHERE CONTAINS(i.txt1, 'FUNCTION', 1) > 0 OR CONTAINS(i.txt2, 'FUNCTION', 2) > 0 OR CONTAINS(i.txt3, 'FUNCTION', 3) > 0 ORDER BY RANK;

Recommend

  • Fetch the row of next in rank to the “rank of last id”?
  • MYSQL extract json elements where the json contains
  • Incorporating an incrementing value into this sql
  • Copy specific columns for particular row (not entire row) into another sheet - Excel Macro
  • Language for web scraping JAVASCRIPT content
  • failed to instantiate one or more class in android studio
  • Mediafire developer doesn't show me Create new app
  • problems with 'com.android.support:appcompat-v7.27.1.1' in the gradle file
  • A larger heap for the Gradle daemon is recommended for running jack
  • :app:transformClassesWithMultidexlistForDebug FAILED
  • PrimeFaces input components are not highlighted on validation error
  • Copying timestamp columns within a Postgres table
  • How do I improve Rails / Paperclip image compression inside or ImageMagick / Rmagick?
  • Including Python.h in Qt application causes undefined reference to Qt functions
  • Web API Basic Auth inside an MVC app with Identity Auth
  • Eclipse GUI building [duplicate]
  • Add Special Case to Power BI Query (M)
  • How do i do the following curl command in Java
  • IE8 stops network access after 5 long polling request
  • Failed to read schema document 'http://www.springframework.org/schema/tool/spring-tool-4.1.xsd&
  • Proguard Exception java.io.IOException: Duplicate zip entry
  • Is there an HTML code that can make my background picture transparent and my text non-transparent?
  • ASP.NET MVC2 Error: No parameterless constructor defined for this object
  • Initialization section of the package
  • MRO with multiple inheritance in python
  • Alamofire and Reachability.swift not working on xCode8-beta5
  • How can we prepend rows to a react native list-view?
  • Compiling dlib on OS X
  • Unable to decode certificate at client new X509Certificate2()
  • Needing to do .toArray() to get output of mongodb .find() on key name not value
  • Problems to linebreak with an int in JLabel
  • Sending data from AppleScript to FileMaker records
  • Symfony2: How to get request parameter
  • Display Images one by one with next and previous functionality
  • How to get next/previous record number?
  • How do you join a server to an Active Directory (domain)?
  • How does Linux kernel interrupt the application?
  • Busy indicator not showing up in wpf window [duplicate]
  • Why is Django giving me: 'first_name' is an invalid keyword argument for this function?
  • How can I use `wmic` in a Windows PE script?