Home » Server Options » Text & interMedia » Contains function with CLOB not working anyone know why?
Contains function with CLOB not working anyone know why? [message #163045] Tue, 14 March 2006 15:08 Go to next message
tracilee123
Messages: 2
Registered: March 2006
Junior Member
Searching for a text string in a CLOB using the contains() function
returns 0 rows (where 2 are expected):

SQL> select clob_column from view where contains(clob_column,
'text_string', 1) > 0;

However, the dbms_lob.instr() function works as expected:

SQL> select clob_column from view where dbms_lob.instr(clob_column,
'text_string',1,1) > 0;

I've verified that Intermedia is installed and valid by running the
imchk.sql script.

Why won't the contains() function work?

Re: Contains function with CLOB not working anyone know why? [message #163054 is a reply to message #163045] Tue, 14 March 2006 17:04 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
What words are you searching for? Perhaps they are stop words (common words that Oracle Context ignores, like the, and, or, etc.)
Re: Contains function with CLOB not working anyone know why? [message #163203 is a reply to message #163054] Wed, 15 March 2006 08:32 Go to previous messageGo to next message
tracilee123
Messages: 2
Registered: March 2006
Junior Member
This is occuring with any text string that I enter. I am not sure if it is operating system specific because I moved the same statement to the sun I am getting the proper results. Problem is the production version is currently Linux.
Re: Contains function with CLOB not working anyone know why? [message #163211 is a reply to message #163203] Wed, 15 March 2006 09:20 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
And is the index up to date?

MHE
Previous Topic: What am I missing in CTX Setup?
Next Topic: How to Hide an XML Section
Goto Forum:
  


Current Time: Fri Mar 29 00:06:04 CDT 2024