| Contains function with CLOB not working anyone know why? [message #163045] |
Tue, 14 March 2006 15:08  |
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
