This discussion is archived
1 Reply Latest reply: Oct 22, 2012 8:15 AM by Roger Ford RSS

Oracle Text - Section Group Parameter

tammyt Newbie
Currently Being Moderated
Hello,

Has anyone had success with creating a text index using the section group parameter? The problem that I am having is when I create my text index and perform a query using Score, I do not get the correct results back.

select score(1) from mybaby where contains(name,'Mommy',1)>0;
  • 1. Re: Oracle Text - Section Group Parameter
    Roger Ford Expert
    Currently Being Moderated
    Yes, many people have. You need to be a bit more explicit about what you're trying to do - at a minimum we'd want to see your CREATE_SECTION_GROUP command and the CREATE INDEX statement.

    Your query isn't using a section - I'll make a wild guess and say that perhaps you've added a FIELD_SECTION to your section group, but you haven't set the VISIBLE parameter to "Y". If that's the case you might find "Mommy WITHIN sectionname" but not just "Mommy".

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points