OraFAQ Forum: Text & interMedia » [CONTAINS] No result whereas there are

Home » Server Options » Text & interMedia » [CONTAINS] No result whereas there are (Oracle Text / Oracle Database Entreprise Edition, v9.2.0.8, Windows 2000)

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

[CONTAINS] No result whereas there are [message #294724]

Fri, 18 January 2008 11:53

morphee7
Messages: 1
Registered: January 2008
Location: France

Junior Member

Hi,

I'm using Oracle Text indexes on a v9.2.0.8 database on windows 2000 SP4.

I have granted my user with the CTXAPP role, created the indexes, added data in the indexed columns (varchar2 and CLOB), rebuilt the indexes.

But whatever the word I'm searching for, I have no result !

Sample of query :

SELECT ID 
FROM MY_TABLE WHERE CONTAINS (TITLE, 'classification',1) > 0

=> No rows returned

But whith

SELECT ID 
FROM MY_TABLE WHERE dbms_lob.instr (TITLE, 'classification',1,1) > 0

=> 1 row returned !!!

I've searched every where : checking grants, index creation, package installation, stoplist, and so on ... nothing. I would be grateful if someone could help me.

Thanks.

Report message to a moderator

[Message index]

		[CONTAINS] No result whereas there are By: morphee7 on Fri, 18 January 2008 11:53
		Re: [CONTAINS] No result whereas there are By: Barbara Boehmer on Fri, 18 January 2008 15:07

Previous Topic:	CTXCAT / CONTEXT index
Next Topic:	oracle text contains near

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:08:17 CDT 2024