Re: Req help comparing against CLOB?

You're using the worng command for this type of comparison.

The command is specific to a CLOB type and it's in the DBMS package.

It's explained in the Oracle8: The Complete Reference and it's on page 671-673 with a nice code example.

Kristian

Rich Gilmour wrote:
>
> 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 - 17:15:47 CDT