Re: Long to Varchar2

       Hi Rahul,
       You probably will have to write a pl/sql block.
       Before "Declare" statement  in pl/sql block

       set long <1000 >
       In "fetch"  for the cursor declared , get search_condition into
       a variable of varchar2....

       Size of varchar2 variable should be more than that set for
       long....


                      Hope this helps a bit..................
                                     shreepad.