CLOB the right datatype?

I have a database that will have some chunks of text that I need to be able to search in queris. The text will be around 6K per item so I can't use a VARCHAR2. I wondered if CLOB was the ideal datatype for this instance? Can I QUERY based on the contents of a CLOB type?

I tried:
select my_clob from test_table where my_clob like '%<search string%';

and got an error saying that there were inconsistent data types. The Oracle DBA at my client's company says that I can do this (or something similar perhpas in another way?) Is this right? _CAN_ I return results based on a matching substring in a CLOB? If so, how do I do this? I cannot index a CLOB, right? How slow will this search be with 3000 rows on modern Sun hardware?

Thanks!

shaft_at_meanmutha.com
http://www.meanmutha.com Received on Wed Dec 22 1999 - 12:23:50 CST