Req help comparing against CLOB?

From: Rich Gilmour <richg_at_aaepa.com>
Date: Mon, 19 Jul 1999 13:47:53 -0700
Message-ID: <7n02pl$40s$1@nusku.cts.com>

Hello all.

Am trying to construct a SQL statment that compares a search term entered via a web form against an Oracle CLOB field. Trouble is, I get the following error :

Database error:

[SERVERERROR] Error from Server: ORA-00932: inconsistent datatypes

Currently, I've constructed my SQL like this :

select * from content where content_text LIKE '%$search_term%' ----- which gives me the above error. Could somebody please explain how to get around this?

Mucho thanks in advance,

Rich Gilmour Received on Mon Jul 19 1999 - 15:47:53 CDT