I am stuck in a situation where need to find an efficient solution to a problem related to search on CLOB objects.

I am through with successful insertions and updations on CLOB objects. But I am finding it difficult to search my table using the CLOB as the key. The only way I find it possible right now, is to read all the CLOB object into my JSP and then search for the keywords in the CLOB object.

I know that it is possible to perform the searches on the CLOB object, and would like to know if someone would have done such a thing, and if yes, I would really appreciate his/her help.

Thanks and Regards