OraFAQ Forum: Text & interMedia » Needs to create stop list for non English

Home » Server Options » Text & interMedia » Needs to create stop list for non English

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Needs to create stop list for non English [message #612642]

Wed, 23 April 2014 01:40

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

Report message to a moderator

Re: Needs to create stop list for non English [message #612647 is a reply to message #612642]

Wed, 23 April 2014 02:12

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: Needs to create stop list for non English [message #612673 is a reply to message #612647]

Wed, 23 April 2014 03:24

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?

Report message to a moderator

Re: Needs to create stop list for non English [message #612723 is a reply to message #612673]

Wed, 23 April 2014 14:58

Barbara Boehmer
Messages: 9104
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 01:54:46 CST 2025