Search Clob Field

Searching clob field

[julep821]

Is there a way to do a search on a clob field (long)?

I am currently getting inconsistent datatypes errors.

I have something like:

select id, date, time,
from desk
where dbms_lob.instr(wlog,(lower'ABCDEFG'),1,1)>0);

[julep821]

I realize that in my example I forgot to put parenthesis around the lower clause.

[coopster]

Is the database Oracle?

A quick search brings up a relative discussion. Although the discussion is regarding searching XML data, the data is stored in a clob column type and one of the posters describes in detail some possible solutions that may be your answer as well. You may want to have a look:

[answers.google.com...]

[julep821]

Thanks I'll have a look at that, it is for an Oracle db.