Home » Server Options » Text & interMedia » Needs to create stop list for non English
Needs to create stop list for non English [message #612642] Wed, 23 April 2014 01:40 Go to next message
rameshaimhigh@gmail.com
Messages: 10
Registered: October 2013
Junior Member

Hi Everyone,

I tried to create new non-English stop list. i got the below error. Could you please help this.

Script:
begin
ctx_ddl.add_stopword('eduk_article_stoplist','время');
end;

Error i got:
ORA-20000: Oracle Text error:
DRG-12507: stop word время already exists in this stoplist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 551
ORA-06512: at line 2
Re: Needs to create stop list for non English [message #612647 is a reply to message #612642] Wed, 23 April 2014 02:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Isn't this self-explanatory?
Quote:
DRG-12507: stop word время already exists in this stoplist
Re: Needs to create stop list for non English [message #612673 is a reply to message #612647] Wed, 23 April 2014 03:24 Go to previous messageGo to next message
rameshaimhigh@gmail.com
Messages: 10
Registered: October 2013
Junior Member
Little - Thanks for your reply. Yes i understood the error. it is telling like this word is already existing. But My problem is i have tried to create this first time then also it is telling like already existing. that is my thing. is there any in build stop word?
Re: Needs to create stop list for non English [message #612723 is a reply to message #612673] Wed, 23 April 2014 14:58 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Can you post a copy and paste of what you tried? Did you create this stoplist or did it already exist? Perhaps you have added an extra / after adding the stopword, causing it to try to add it a second time. Please see the demonstration below that shows creation of the stoplist, addition of the stopword, then produces the error you get when attempting to add the same stopword a second time, then removal of the stopword, then addition of the stopword again, then droping the stoplist. Can you remove the stopword, then add it again?

SCOTT@orcl12c> begin
  2    ctx_ddl.create_stoplist ('eduk_article_stoplist');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> begin
  2    ctx_ddl.add_stopword ('eduk_article_stoplist','время');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> begin
  2    ctx_ddl.add_stopword ('eduk_article_stoplist','время');
  3  end;
  4  /
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-12507: stop word время already exists in this stoplist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVLSB", line 838
ORA-06512: at "CTXSYS.CTX_DDL", line 827
ORA-06512: at line 2


SCOTT@orcl12c> begin
  2    ctx_ddl.remove_stopword ('eduk_article_stoplist','время');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> begin
  2    ctx_ddl.add_stopword ('eduk_article_stoplist','время');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> begin
  2    ctx_ddl.drop_stoplist ('eduk_article_stoplist');
  3  end;
  4  /

PL/SQL procedure successfully completed.

Previous Topic: Domain index DEFINESCORE
Next Topic: Text Index returns column name as well
Goto Forum:
  


Current Time: Thu Mar 28 17:34:16 CDT 2024