I am trying to search for a string in the clob field of one my tables. Previously is used to employ the 'like' keyword for all the varchar fields and was working fine. Now when I am trying to do so with the clob field I am getting an exception like 'inconsistent datatypes'.
Can anyone, give me an example query or anything like that. Any help will be greatly appreciated.