Re: query on Long data type

Long Columns can not be used in the where clause. Your options are few and vary depending on the version of oracle you are using:

1. Install Oracle ConText/or Intermedia Text which will allow you to reference Longs in a where clause.
2. Convert the Longs to LOB's

<colormouse_at_my-deja.com> wrote in message news:8dte56$6aa$1_at_nnrp1.deja.com...
> Experts:
>
> I stored the body of the posting into database as LONG data type
> since they are characters more than 4000. I tried to query this field
> like: (select * from t_posting where body like '%keyword%'), failed
> because Oracle pop up a error: ORA-00997: illegal use of LONG datatype.
> I can do this query against Varchar2 but this data type too small.
> Please tell me how do the query like this asap (deadline is
> comming).
> Thanks a lot.
>
> Color Mouse
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Apr 24 2000 - 00:00:00 CDT