query on Long data type

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 Sat Apr 22 2000 - 00:00:00 CDT