Re: How to search a LONG column

You can write a pl/sql function and include it in the WHERE clause. A problem is that the longest pl/sql variable is only 32k. If the long is larger than this you can read it in 32k chunks and achieve the same effect.

Of course the performance ain't great but it is at least possible.

Ian

On Fri, 27 Mar 1998 09:27:09 -0500, Cary Moore <cjmoore_at_compuserve.com> wrote:

>
>
>According to the docs you can't reference a LONG column in a WHERE clause,
>one of the many restrictions with LONGS!
>
>Part of our application allows users to set filter conditions including
>the ability to word search, is there any way we can word search text
>stored in a LONG?
>
>Cary
Received on Sat Mar 28 1998 - 00:00:00 CST