Re: How to use LONG field in the Where clause

You can either use the intermedia text engine and create an index on the field.
You can convert the long to a lob and use a function there. (long is deprecated, does msg_content really need to be over 4000 bytes? if not then use varchar2)
You can write your own pl/sql function that parses out the long in 32 K chunks and looks for a particular string.

Jim
"Rangeshwara Reddy Kona" <konareddy_at_hotmail.com> wrote in message news:3bf1fb15_at_news.cadence.com...
> Hi all,
>
> Message contain date like 'Reached bad state' 'Error'
> I want to find the records which are having 'Error' in it.
> I can't use
> select * from atc_message_log where msg_content like '%Error%';
> Thanks in Advance.
> Rangesh
>
> SQL> desc atc_message_log;
> Name Null? Type
> ----------------------------------------- -------- ----------------------

--


> ---

>

>  OBJ_ID                                    NOT NULL NUMBER(9)

>  COMP_ID                                   NOT NULL NUMBER(9)

>  INTEGRATION_ID                            NOT NULL VARCHAR2(300)

>  WORK_UNIT_ID                              NOT NULL NUMBER(9)

>  MSG_NBR                                   NOT NULL NUMBER(9)

>  TIMESTAMP                                 NOT NULL DATE

>  SEVERITY                                           NUMBER(5)

>  MSG_CONTENT                                        LONG

>

> SQL>

>

>

>

>